Query from 2 Tables

[Richard G]

I have a set of data in one table with another set of data in a seperate table, both tables have been linked so I have a MAX and MIN set of values -this works fine however I now wish to work out the difference ie;
MAX - MIN = ? but I now get an error as the data is in 2 different reference tables which are set by an external source so I have to use both tables linked by a common thread, I use the Date - any ideas how I can resolve this issue

Regards

Richard G

 

[neileg]

Presumably you've joined the two tables in a query using the date as the join field and used a calculated field to subtract the two values. If yes, in what way didn't it work. If no, then that's what you need to do.