Can I make a positive number negative?

[stacey78]

I have a report RPT INVOICES based on query QRY INVOICES. In this query there are invoices "I" and credit notes "C". All the money values for these are positive. What I need to do is in the report make these credit note values as a negative so I can total these values up accurately. How can I do this?

 

[nickjar2]

Hi,

This query produces negative numbers:

SELECT [fieldName]-(2*[fieldName]) AS negativeNumber
FROM [TableName];

Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)