Query changing format

[John Southern]

I have a series of SELECT Queries culminating in a MAKETABLE query which is the data source for a report.
The field [GOODS_AMOUNT] formatted as currency comes unscathed through the queries untll the last one.
In this query it is used in a calculated fields as follows:-

90Days: iif([Overdue]<=-3,[GOODS_AMOUNT,"")
60Days: Iif([Overdue]<=-2,[GOODS_AMOUNT},"")


etc

The fields 90Days,60Days etc arrive formatted as text which means I am unable to sum them in the report.
How do I make sure that they are currency fields, why do they change?

John

[NoellaG]

Hi John,

try:
90Days: iif([Overdue]<=-3,[GOODS_AMOUNT],0)
60Days: Iif([Overdue]<=-2,[GOODS_AMOUNT],0)

grNG

[John Southern]

NoellaG,
Thanks for that I will try it.
John

[John Southern]

NoellaG
That worked , thanks a lot. I also tried forcing a format which did strange things to negative numbers (credit notes). I will mark as solved.
John