Date Range Query to Recognise No of Days in Month

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

Guest

Hi All

I have put together a query which looks up a date range using the Between
And function. If though i put in a date which is not valid ie. 31/06/07 all
records are returned. Is there a way i can put some form of validation in to
avoid this happening?

Reagrds
Mike
 
Apparently you are using a parameter prompt in your query. Don't. Use a
control on a form for all criteria. This allows you to use a calendar for
date entry and/or validate the criteria prior to opening any form, report, or
query.
 
Back
Top