Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top