how do i specify search criteria for a range

[Guest]

I have figured out how to import data from excell to access. Now i need to
figure out these queries. For exapmle say i want to pull up all data submited
from date range 11/05/2005 to present. How do i set up the querie so that i
can go in and randomly pull data from any date range?

 

[fredg]

I have figured out how to import data from excell to access. Now i need to
figure out these queries. For exapmle say i want to pull up all data submited
from date range 11/05/2005 to present. How do i set up the querie so that i
can go in and randomly pull data from any date range?

As criteria for the DateField, write:
Between [Enter Start Date] and [Enter End Date]

You will be prompted for both dates.

 

[Allen Browne]

fredg's answer is the simplest solution for you.

If you want more details and another alternative, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have figured out how to import data from excell to access. Now i need
to
figure out these queries. For exapmle say i want to pull up all data
submited
from date range 11/05/2005 to present. How do i set up the querie so
that i
can go in and randomly pull data from any date range?

As criteria for the DateField, write:
Between [Enter Start Date] and [Enter End Date]

You will be prompted for both dates.