How I can make a Parameter query in Access on Date Field to find date range or All Dates ?

Question

Dear Members,

I am trying to make parameter query in Access, between[Date1] and [Date2] , this is Ok, but If I need all dates, I give * in both User Input box, but It gives me error, please tell me how I can get all dates by give parameter value "*" in the field.

Answer 1

Use the criteria:
Between [date1] And [date2] Or Like "*"

Now when you run the query, if you want all dates, don't put anything in date 1 or date 2 prompts, just click OK and the query will return all dates.

Answer 2

check if both fields filled by "*" use another SQL statement:
select * from [table]
it's best solution!