Hi Richard I have two columns of date fields(LeaveFrom and LeaveUpto) and I want a report based on date provided in query. Example: All leaves taken between i.e from 21 January 2012 upto 20 February 2012.
Reply from Richard Rost:
Your query criteria would be:
LeaveFrom: BETWEEN #1/21/12# AND #2/20/12#
OR (down a row)
LeaveUpTo: BETWEEN #1/21/12# AND #2/20/12#
This should catch anyone where their leave falls anywhere in that date range.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
