Criteria based on user input

[vincentsp]

I have a Time sheet query with a field "Date" and a field "Time" the criteria for the "Date" is based on a user input as follows.



>=[Start date] And <=[End date]

Now I'm trying to set a criteria on the "Time" field to only return the records where the time is > 17:00:00 if the "Date" < then the [End date].

The problem I have is how to refer to the user input [End date] criteria from the "Date" field.

Hopefully this makes sence.

[June7]

Date is a reserved word in Access/VBA. Should not use reserved words as field names.

Is the Time field a date/time data type?

I never use dynamic parameter input popups. Cannot validate user input.

Review http://www.allenbrowne.com/ser-62.html

[ssanfu]

Note that "Time" is also a reserved word......

[vincentsp]

Probably a bad example using Time and Date in my question.
In my original Query the fields are called TimeSheetDate, StartTime and EndTime, all Date/Time type fields.

I'm using the user input just to select which time sheets to print, based on the date ( [start date] and [end date] ).
But I would like to set a criteria on the StartTime >=13:00:00 for all the dates < [End date]

[June7]

I've never needed to filter records by a time value. From the few times I've helped someone with that, I found it to be tricky.

I don't understand why the time is relevant to printing a timesheet. Shouldn't this be by pay period?