Date Criteria in qry

[sandhurstUK]

I currently have a parameter qry which calls for the operator to enter the current month in order that the required records are returned, and am looking to automate the operation.

What I need is for the qry to look at the 'system' month and return all entries between day one of the month and the current date.

I have been playing around with:

Between (DatePart "mm",) And Date()

and various other permutations but to no avail.

Any ideas gratefully accepted
Thanks

 

[pdx_man]

Check out this thread:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37801

 

[sandhurstUK]

Many Thanks

Thanks for the response.

When I saw the solution I knew what the answer to my question was, which incidentally I should have already known as I had a similar problem some time ago which was resolved using the Format function. Just couldn't remember where to look.

Ian