Parameter query

[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'.
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:00 and time2 = 23:59:00

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 a record with the time 14.57 but not 15:30.

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

Thanks

RussG

 

[SOS]

Personally, I keep the date and time together in a field as it makes using the functions much simpler and criteria too.

 

[RussG]

Thanks for your reply. Thats won't work for me. I need to look at a range of dates i.e. 1st - 7th July and return 'Events' that happened say between 1 & 3 pm for each of those days
so I need to seperate the dates and times.
Thanks
RussG

 

[RussG]

Thanks for your reply. Thats won't work for me. I need to look at a range of dates i.e. 1st - 7th July and return 'Events' that happened say between 1 & 3 pm for each of those days
so I need to seperate the dates and times.
Thanks
RussG

Sorry double post, PC went ga ga