Report limiting by date/time

[Roosters]

In a table I have a 'Time_Out' field. This field has a date/time entry "01/01/01 16:00:00". I need to limit a report between two dates (which I have done) but also display only times between 'start_time' and 'end_time" within this data range. I have a user form to get the date range and propose to use the same form to enter the time range.

The query criteria for 'Time_Out' is
>=[forms]![staff]![start] And <=[forms]![staff]![end]

the time fields on my user form are [time_start] and [time_end]

Hope this makes sense!
Thanks Phil.

 

[Databaseguy]

Should be

Between[forms].[staff].[time_start] And [forms].[staff].[time_end], assuming the name of the form is staff.

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy