Date

N

nir020

I have created a table on access which shows payments made by me over the
last year.

Can you let me know how to create a query which when accessed allows the
user to view a data from this table from a certain time period (for example
from the months of May and June) that he or she selects when the query is
opened.
 
F

Frank Stone

hi,
In your query's design view, in the date fields cirteria
box put this
=[enter a start date] and < [Enter an end date]
Click to expand...
(or something similar)
The query will display all entries between the 2 dates
that you enter.
 
Top