Hi , hoping someone can help me with this!
I have the following query criteria which checks for dates between 2 date textboxes, or returns everything if dates are not entered.
>=[Forms]![RMS HISTORY]![FromDate] And <=[Forms]![RMS HISTORY]![ToDate]+1 Or is null
This works great, but I also want to add time boxes to check be able to check between 2 times.
There is a Time field in the table, so I thought it would be easy to just repeat the above but point to Time field and Time textboxes:
>=[Forms]![RMS HISTORY]![FromTime] And <=[Forms]![RMS HISTORY]![ToTime]
But it seems Access can only handle one of these statements at a time, and it doesn't work.
How do I work around it?
What is the best method to set this up?
Best regards
Mark