Help Need with Query Criteria!!

[Newguy28]

Hey Guys,

What i want to be able to do, is that when a user clicks on a report, they are asked to enter a month and only the records with that month will be displayed!! What expression can i enter in the citeria of the query, i did try =like"month" but that means creating a query for every month of the year!!!

Thanks in advance guys!!

 

[neileg]

Create a calculated field in your query that extracts the month using Datepart and apply the criterion to that.

 

[Newguy28]

What i mean is that when the user clicks on a the report, a box will appear which asks them to select a month. They then enter a month and all files with that month in will be displayed!!

 

[neileg]

Read up on parameter quries in Access help. You will understand my advice will give you what you want.