Time search Query

[Davism4]

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

[CJ_London]

'doesn't work' doesn't help use to help you - you get an error? wrong result? something else?

It may be obvious to you but not us - provide some example data, example criteria and the result required

As a general comment usually better to combine your date and time fields and form fields and compare the result, but you haven't said what you expect as a result so maybe not

Are you sure the time fields only contain time (i.e. the date element is 0)?

And what are the users actually entering on the form

[Cottonshirt]

I take it this is a WHERE statement ?

if so, try this

WHERE (((([fieldname])>=[Forms]![RMS HISTORY]![FromTime]) And (([fieldname])<=[Forms]![RMS HISTORY]![ToTime])))

good luck with your project,



Cottonshirt

[CJ_London]

think the OP's code is based on what they see in the query builder, not in the sql. Sql view would show the code as you have it.

[Welshgasman]

You could try adding the date and time controls?
They are numbers after all?

[CJ_London]

think the OP has gone away