Date activated query!

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

If my tblHorseInfo has these fields HorseID.Number, DateAlert.Date/Time ,
AlertInfo.Text
How would I design the query to show this on the Date Set
I am going to have a Listbox [ListAlert]on my Main Menu that will be visible
when there is a record to Show
Me.ListAlert.Visible = IIf(Me.ListAlert.ListCount = 0, False, True) showing
these 3 fields
 
Bob Vance said:
If my tblHorseInfo has these fields HorseID.Number, DateAlert.Date/Time ,
AlertInfo.Text
How would I design the query to show this on the Date Set
I am going to have a Listbox [ListAlert]on my Main Menu that will be
visible when there is a record to Show
Me.ListAlert.Visible = IIf(Me.ListAlert.ListCount = 0, False, True)
showing these 3 fields
Click to expand...
Ok worked it out :)
SELECT tblHorseInfo.HorseID, tblHorseInfo.MemoDate, tblHorseInfo.MemoText
FROM tblHorseInfo
WHERE (((tblHorseInfo.MemoDate)<Now()) AND ((tblHorseInfo.MemoText) Is Not
Null));
 
Back
Top