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

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


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?