using calculation in query

[waymond]

I have a sum calculation I need to use in a query
Total: ([raised]-[disbursed]) expression
How do I get this in the table for the total field.

Lets say my table is called funding

 

[AlexCuse]

select ([raised]-[disbursed]) as TOTAL from FUNDING

or in query designer:
Total: (FUNDING.[raised]-FUNDING.[disbursed])

If your integers are stored as text however, you will need to use the format function to get them to numbers.

Hope this helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".