Time parameter

[RussG]

I am having a problem setting up a parameter to filter times.

My table collects ' event ' dates and times data in separate fields.

I have set the time field to 'short time' 00:00.

In my query I have a parameter to filter dates i.e Between forms!frmDial!date1And forms!frmDial!date2 and this all works fine.

What I need to do is to filter this further on the time field so I can report on all events between selected dates that occured between say 1pm & 3pm.

So, in my query on the time field I have Between forms!frmDial!timefrom And forms!frmDial!timeto

on frmDail I have set the time fields as default values
time1 = 00:01 and time2 = 23:59
so, unless I select different times everything should be returned between my selected dates.

This isn't working, I am only getting back half the records that are valid for my date period and the times seem arbitory, I get records with the time 14.57but not 15:30.

Sure this is going to be something obvious but would appreciate any suggestions.
Thanks
RussG

 

[Galaxiom]

Check if the time field in the table is actually a Date&Time value in a field formatted as time.

 

[RussG]

Yes , definitely Date/Time field with the fornmat set to Medium Time.

Apologies this question also appears under the heading Parameter Query, my PC crashed at work when I was posting and I thought it was lost.

Thanks
RussG

 

[RussG]

Resolved this, created a seperate query to filter by time and added to my main query.

RussG