Hello,

I am in desperate need of figuring out this time issue.

I really need to extract data between particular dates between 8:30 AM and 8:30 AM of the next day. I have tried the between function but it is not pulling all of the data. I will need the user to enter a start date and end date (see parameter).

Here is my current parameter:

Between [Forms]![criteria_export_trouble_tkt_records_rpt_dialog]![BeginDate] And [Forms]![criteria_export_trouble_tkt_records_rpt_dialog]![EndDate]

I am using the following date and time fields:

Enter_date
Enter_time

I would really appreciate any help I can get. I have been at this for awhile and do not have advance experience to resolve it.

Thanks to anyone who can help.


MLR

Mary-
What IS it pulling out? Is it missing dates/Times?

Loralee

Hi Loralee,

No, I receive the dates/times. I am missing records between certain times. For examples, If I run a query from 6/16/06 thru 6/17/06, I receive the records (dates/times included) from 8:30 AM thru 6:12 PM. It begins it's output for 6/17 at 9:07AM. So, I am totally missing records from 6:13 PM to 9:00 AM (see below).
The records missing seem to be from "C" shift.

We have three shifts:
   A=8:00 AM - 4:00 PM
   B=4:00 PM - 12:00 AM
   C=12:00 AM - 8:00 AM

I hope I did not confuse you. I have listed my output below.

Thanks so much for your help.

Enter Date Enter Time shift
6/16/2006 9:12:42 AM A
6/16/2006 9:49:38 AM A
6/16/2006 10:38:32 AM A
6/16/2006 11:15:52 AM A
6/16/2006 11:20:53 AM A
6/16/2006 12:31:24 PM A
6/16/2006 12:33:33 PM A
6/16/2006 12:34:06 PM A
6/16/2006 12:40:00 PM A
6/16/2006 2:28:49 PM A
6/16/2006 2:35:25 PM A
6/16/2006 2:36:47 PM A
6/16/2006 3:06:58 PM B
6/16/2006 3:11:43 PM A
6/16/2006 3:42:33 PM B
6/16/2006 3:43:35 PM B
6/16/2006 4:30:00 PM B
6/16/2006 5:05:00 PM B
6/16/2006 5:49:00 PM B
6/16/2006 5:52:55 PM B
6/16/2006 6:02:51 PM B
6/16/2006 6:08:37 PM B
6/16/2006 6:12:12 PM B
6/17/2006 9:07:51 AM C
6/17/2006 9:09:07 AM C
6/17/2006 9:09:13 AM C
6/17/2006 9:09:17 AM C
6/17/2006 9:09:22 AM C
6/17/2006 9:09:26 AM C
6/17/2006 9:09:30 AM C
6/17/2006 9:09:35 AM C
6/17/2006 9:09:39 AM C
6/17/2006 9:09:50 AM C
6/17/2006 9:09:55 AM C
6/17/2006 9:10:03 AM C
6/17/2006 9:10:08 AM C
6/17/2006 9:10:16 AM C
6/17/2006 9:10:20 AM C
6/17/2006 9:10:24 AM C
6/17/2006 9:10:28 AM C
6/17/2006 10:04:35 AM A
6/17/2006 10:33:00 AM A
6/17/2006 11:26:48 AM A
6/17/2006 12:22:26 PM A
6/17/2006 12:26:57 PM A
6/17/2006 3:01:26 PM A
6/17/2006 3:35:59 PM A
6/17/2006 4:48:47 PM B


MLR