Show data between dates for a selected date

[taranto]

Hi

I think my question is similar to those previously asked, but differs as it does not contain 2 selection dates in the selection field, but only 1.

I have a form for when a person is on duty- so it has name, dateon and dateoff.

Each day at 23:59 a daily report is produced which amongst other things that have happened during the past 24 hours, shows the person on duty for the selected day. This report is generated by entering a date on a form, the date been that required for that day's specific report.

It is ok if the date is the same as the dateon, but my problem is that I cant get the report to show a chosen report date that is not the dayon.
i.e if Mr Smith is on duty from 10/12/12 until 15/12/12 and I select the daily report for the 13/12/12, it should still show Mr Smith

I have tried a variety of criteria (<= etc) in my query, but am still at a loss to finding the solution. I know I want something that is between (and including) dateon/dateoff, but dont know where to construct it.

Any pointers greatfully received

Many thanks

 

[taranto]

All

thanks for looking, I suddenly had a Eurika moment and have solved it

Cheers