Showing results from a query

[hooby1]

Does anyone know how to do a query so that the user can find all the things that will expiry at the end of the current month?
The user will click on a command button and it will show the results of a product that will expiry at the end of a current month.
Have tried with parameters to which the user manually types the end date in and then it will show the results but having problems.
Cheers

 

[FoFa]

Is the expiration date always the last day of the month?

 

[hooby1]

Yes it is the last day of the month

 

[FoFa]

What problems are you having? basically if you have them type a date, in your criteria you should have something like:
#[Please Enter Month End Date MM/DD/YYYY]#

 

[hooby1]

Cheers

Cheers.
It appears that is the line I wanted and all seems to be working.
John.