K
keano
Hi
I have spent the whole day and I can not merge data from two tables into one
table. Here is my problem.
Table 1 has data for each hour since April 1 2008. Let's say Number of
vehicles on an interesection) 4000 records
Table 2 has data for some hours since April 1 2008 (it is a daily occurance,
so I might have data for each hour on the 22nd, but nothing on the 23rd or
the 24th). Let's say there was 5 trucks that passed on the 23rd but not on
the 24th. 500 records.
I want to get the data in Table 1 adjusted for the hours in which there were
trucks in the interesections. So in total I would have 4000 records, but on
the 23rd my sum of vehicles would be 5 vehicles less., but on the 24th would
be the total count of table 1.
I have tried and tried to apend, etc, but I run into the problem that when I
append data from table 2 into table 1 the data is on new records. It is not
matching the hours and then simply filing the trucks column. I do not want
new records.
Help!
I have spent the whole day and I can not merge data from two tables into one
table. Here is my problem.
Table 1 has data for each hour since April 1 2008. Let's say Number of
vehicles on an interesection) 4000 records
Table 2 has data for some hours since April 1 2008 (it is a daily occurance,
so I might have data for each hour on the 22nd, but nothing on the 23rd or
the 24th). Let's say there was 5 trucks that passed on the 23rd but not on
the 24th. 500 records.
I want to get the data in Table 1 adjusted for the hours in which there were
trucks in the interesections. So in total I would have 4000 records, but on
the 23rd my sum of vehicles would be 5 vehicles less., but on the 24th would
be the total count of table 1.
I have tried and tried to apend, etc, but I run into the problem that when I
append data from table 2 into table 1 the data is on new records. It is not
matching the hours and then simply filing the trucks column. I do not want
new records.
Help!