Date

[Guest]

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.

 

[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]

(or something similar)
The query will display all entries between the 2 dates
that you enter.