T
tmm786
Hello,
I am trying to use a query to filter the table results by Date and
Time. The table data is in the format:
mm/dd/yyyy HH:MM:SS *M
I already have a query that selects the data between two dates. But I
also want to be able to select two dates and two times. Such as
Between 3/15/2007 9:00 AM and 3/15/2007 10:00 AM, or use two different
dates and times, etc.
I have gotten close by using:
Between ([Forms]![RC_WithTime]![Calendar1]+TimeSerial(9,0,0)) And
([Forms]![RC_WithTime]![Calendar2]+TimeSerial(10,0,0))
but as soon as I try to convert the TimeSerial to link to forms it
says that there is an error or it is too complex.
Is there a way to do this?
I am trying to use a query to filter the table results by Date and
Time. The table data is in the format:
mm/dd/yyyy HH:MM:SS *M
I already have a query that selects the data between two dates. But I
also want to be able to select two dates and two times. Such as
Between 3/15/2007 9:00 AM and 3/15/2007 10:00 AM, or use two different
dates and times, etc.
I have gotten close by using:
Between ([Forms]![RC_WithTime]![Calendar1]+TimeSerial(9,0,0)) And
([Forms]![RC_WithTime]![Calendar2]+TimeSerial(10,0,0))
but as soon as I try to convert the TimeSerial to link to forms it
says that there is an error or it is too complex.
Is there a way to do this?