Appending question

[Supermurray]

G’day all

What I’m looking for is a way to append data table to one table to another from a drop table. But the issue I am running into is I need a row for each Time interval (30 min interval, Short time format). Here are a few examples

Drop Table (TblDroper) (where the user drops the data from an existing web based report tool)

Time | DeptNum | Date | Incoming | Outgoing | Hand
00:00| 20934 | 05/03/2009 | 5 | 4 | 0:03|
00:30| 20935 | 05/04/2009 | 4 | 6 | 0:09|
08:00| 20932 | 05/02/2009 | 7 | 5 | 0:10|

Above is an interval report example, which is there is no data in the interval it doesn’t include the row/time/dept for the interval. I need an append query to append the data from the drop table to an historical trending table with 0 or blanks in the rows with no data.

Here is what I was trying to get working, I am probably missing something really small like normal.

I have drop table above
I have 2 other define tables, one with all the depts. (Tbldeptdefine) and one with every interval (00:00, 00:30, 01:00, ect) (TblIntervalDefine), I made a query that creates a list of every dept and interval (QryDeptInter). Then I was thinking about making an append query that links to the QrydeptInter then set to show all records from QryDeptInter and ones that match from TblDroper.

But since I am here, I’m missing something

Example of what I need:

Time | DeptNum | Date | Incoming | Outgoing | Hand
00:00| 20934 | 05/03/2009 | 5 | 4 | 0:03|
00:30| 20934 | 05/03/2009 | 0 | 0 | 0:00|
01:00| 20934 | 05/03/2009 | 0 | 0 | 0:00|
01:30| 20934 | 05/03/2009 | 0 | 0 | 0:00|
02:00| 20934 | 05/03/2009 | 5 | 4 | 0:03|
02:30| 20934 | 05/03/2009 | 4 | 6 | 0:09|

Any help or aiming me towards something will help a lot.
Cheers and thanks in advance


Murray
If you have always done it that way, it is probably wrong.
~Charles Kettering~