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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print date criteria 1
Pop-up Box with a reminder 1
Entering a Range of Dates into a Form 5
Form property as query criteria 7
How can I set up a form to search criteria in Access? 4
Capture Dates from Form, Put at Heading of Report 2
#Type! error on form 6
Forcing a date entry format of dd/mm/yyyy 1

Back
Top