Help with writing a query and expression

[jeevenze]

I have the following query:

SELECT qryporeceived.job_number, qryporeceived.SumOfpo_received, tbljob_info.total_estimate
FROM qryporeceived INNER JOIN tbljob_info ON qryporeceived.job_number = tbljob_info.job_number
GROUP BY qryporeceived.job_number, qryporeceived.SumOfpo_received, tbljob_info.total_estimate;

This returns the fields, 'job-number', 'SumOfpo_received' and 'total_estimate'.
I need help writing a query where there's a field that returns the result of total_estimate - SumOfpo_received. (i.e. subtract SumOfpo_received from total_estimate)

I'd be thankful for any responses.
Thank you

Jeevenze

 

[DougP]

If the result is going to end up on a report I would use another text box in the reports footer.

=[total_estimate] - [SumOfpo_received]

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[jeevenze]

Hi DougP,
I'd like the result to be returned in the query...I'm making a webenabled site and I want to create a recordset in ultradev and would like to copy the sql statement to ultradev.
Is there anyway i can return the result in it's own field in a query?

Jeevenze