View Single Post
 
Old October 30th, 2003, 02:46 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you create one table. Put the following fields, or equivalent fields

Dept
Date
AAmount
DAmount

you can create a query an insert a calculated field
NewField: [AAmount]-[DAmount]

And it will give you your result.

You are trying too hard by duplicating the info in two tables. One table is enough and it will not have any issues on joining one table to the other. Anyway, you may not even need to keep the A and D or two dates, or two dept.

Will this work for you?



Sal