Making a date criteria in a form

  • Thread starter Thread starter James Summerlin
  • Start date Start date
J

James Summerlin

Hello Everyone,

I have an Access database that I have already constructed a very cool query
from and a report to go with the query. What I need now is a form,
preferrably one that can be configured to come open when the database is
opened, that will allow a user to type in a date range AND/OR a name to
filter the report from the query.

For example, I want to see all kids that have office visitations (dental
office) between the dates of 08/01/2003 and 08/30/2003.

OR

Kid last name Summerlin for same date range or everything in the database if
no date is entered.

How do I go about doing this? Forms are my weak point.

Any help is greatly appreciated.

Kindest Regards,
James Summerlin
 
See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

The example shows how to build a string based on the dates, and apply that
as the WhereCondition of the OpenReport action. You could extend that to
include the name if it's not null as well.
 
Back
Top