Please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an unbound date field that displays the date on a calender when the a
specific date is pressed. I am trying to develop a query to look up records
based on the date in the unbound field. I cant seem to get the query to come
back with any records even when a date is chosen that has records. Any
suggestions would be greatly appreciated.
 
If the date in the records were entered using Now() they have a time
component and will not match a date without a time component unless they were
entered at midnight.
Try using My Date:Cvdate(Int([YourDateField])) in the query design view
and Cvdate([Forms]![YourFormName]![YourTextBox]) as criteria.
 
If you enter the date directly into the query, do you get records back? If
not, perhaps your date field is also storing a time - Does it use the Now()
function to populate the field? That function returns the date and time.

Try
Between #1/1/05# and #1/2/05# as criteria (obviously substituting valid
dates one day apart).
 
Back
Top