Query Help

[Whitney]

I'm trying to create a query from the below table (using 9/28/07 as example).
The table includes: Received C/S (date), Received (amount), Sign In date
(date completed), amount completed (sum of Filed + Sent to accounting +
Pended). I would like to run a query daily that shows the amount received
that day and the amount completed on the same day and include a backlog field
if the full amount received is not completed.

ID Sign Out Date Sign Out Time Sign In Date Sign In Time Warehouse Received
W/H Received C/S Batch Received Type Agent Filed Sent to Accounting Pended
483 10/1/2007 0:00 9:56 AM 01-Oct-07 1:47 PM Greenwood 9/26/2007 9/28/2007
0:00 5165 40 Complete Refund Shalisha Gainyard 3 36 1
454 10/1/2007 0:00 12:56 PM 01-Oct-07 3:00 PM Greenwood 9/26/2007 9/28/2007
0:00 5164 40 Complete Refund Betty Guevara 1 39 0
455 10/1/2007 0:00 8:00 AM 01-Oct-07 9:27 AM Irvine 9/27/2007 9/28/2007
0:00 5158 27 Complete Refund Betty Guevara 4 22 1
457 10/2/2007 0:00 9:36 AM 02-Oct-07 10:57 AM Greenwood 9/26/2007 9/28/2007
0:00 5147 30 Mixed Betty Guevara 2 26 2
460 10/3/2007 0:00 8:15 AM 03-Oct-07 9:26 AM Irvine 9/26/2007 9/28/2007
0:00 5143 8 Uneven Exchange Betty Guevara 4 4 0
468 10/3/2007 0:00 7:00 AM 03-Oct-07 2:00 PM Irvine 9/28/2007 9/28/2007
0:00 5141 22 Uneven Exchange Brad Johnson 14 6 2
469 10/1/2007 0:00 4:30 PM 01-Oct-07 4:50 PM Greenwood 9/26/2007 9/28/2007
0:00 5162 17 Complete Refund Daniel Lopez 17 0 0
471 10/1/2007 0:00 9:56 AM 01-Oct-07 12:00 PM Irvine 9/26/2007 9/28/2007
0:00 5153 21 Mixed James Echeverria 10 11 0
472 10/1/2007 0:00 12:20 PM 01-Oct-07 12:50 PM Irvine 9/27/2007 9/28/2007
0:00 5157 12 Even Exchange James Echeverria 12 0 0
473 10/1/2007 0:00 12:54 PM 01-Oct-07 3:00 PM Greenwood 9/26/2007 9/28/2007
0:00 5151 30 Mixed James Echeverria 14 15 1
474 10/2/2007 0:00 7:00 AM 02-Oct-07 8:00 AM Irvine 9/26/2007 9/28/2007
0:00 5152 17 Mixed James Echeverria 10 6 1
451 10/1/2007 0:00 4:30 PM 01-Oct-07 4:50 PM Greenwood 9/26/2007 9/28/2007
0:00 5146 11 Even Exchange Ben Wong 11 0 0
476 10/2/2007 0:00 10:00 AM 02-Oct-07 11:00 AM Greenwood 9/26/2007 9/28/2007
0:00 5150 30 Mixed James Echeverria 10 19 1
525 10/4/2007 0:00 7:20 AM 04-Oct-07 8:06 AM Irvine 9/28/2007
0:00 5154 6 Incomplete Refund Betty Guevara 0 6 0
484 10/1/2007 0:00 1:47 PM 01-Oct-07 3:29 PM Greenwood 9/26/2007 9/28/2007
0:00 5163 40 Complete Refund Shalisha Gainyard 1 38 1
485 10/1/2007 0:00 3:29 PM 01-Oct-07 4:17 PM Irvine 9/26/2007 9/28/2007
0:00 5166 21 Complete Refund Shalisha Gainyard 1 20 0
486 10/2/2007 0:00 7:30 AM 02-Oct-07 9:16 AM Irvine 9/26/2007 9/28/2007
0:00 5159 9 Incomplete Refund Shalisha Gainyard 4 4 1
487 10/2/2007 0:00 9:24 AM 02-Oct-07 11:42 AM Toronto 9/27/2007 9/28/2007
0:00 5155 6 Mixed Shalisha Gainyard 2 4 0
488 10/2/2007 0:00 1:01 PM 02-Oct-07 2:51 PM Irvine 9/26/2007 9/28/2007
0:00 5161 13 Incomplete Refund Shalisha Gainyard 6 7 0
491 10/3/2007 0:00 7:37 AM 03-Oct-07 9:00 AM Irvine 9/26/2007 9/28/2007
0:00 5142 22 Uneven Exchange Shalisha Gainyard 12 8 1
493 10/1/2007 0:00 11:10 AM 01-Oct-07 3:45 PM Greenwood 9/26/2007 9/28/2007
0:00 5145 34 Even Exchange Victor Montano 34 0 0
494 10/1/2007 0:00 6:59 AM 01-Oct-07 4:05 PM Greenwood 9/26/2007 9/28/2007
0:00 5144 34 Even Exchange Victor Montano 33 1 0
523 10/4/2007 0:00 7:00 AM 04-Oct-07 11:00 AM Greenwood 9/28/2007
0:00 5180 25 Even Exchange Victor Montano 22 3 0
524 10/4/2007 0:00 7:15 AM 04-Oct-07 8:45 AM Greenwood 9/28/2007
0:00 5160 20 Incomplete Refund Brad Johnson 3 17 0
475 10/2/2007 0:00 8:00 AM 02-Oct-07 10:00 AM Greenwood 9/26/2007 9/28/2007
0:00 5148 30 Mixed James Echeverria 11 19 0