Calculations in a query

[Clem]

Hi, can anyone out there tell me if it is possible to calculate a value in a column in a datasheet view of a query. i.e. I want to take a value in 'Column A' and subtract the value in 'Column B' to create a value in 'Column C'? If it is possible. How?

 

[Minty]

Yes - in the top line of the query criteria design type something like ResultField: [ColumnA] - [ColumnB]

If the Column names are from different tables, and have the same names you would need to include the table names; e.g [table1].[columnA] - [table2].[columnA]

 

[Clem]

Minty, thanks so much that seems to have provided the answer, instead of :banghead: I am

regards Clem