Forcing IIF function to use number type 1

[mollow]

Hi,

I've written a query that performs a calculation to work out a total cost. However sometimes the total cost will have the text 'tba' in it. This means it can't use the SUM function.

I thought i could get around this by using:

IIF([x]="tba", 0, [x])

However, it appears that the 0 is of text type and consequently I still can't use the SUM function.

Am I just being stupid? Is there a way around this problem?

Thanks in advance,

Mike

 

[THoey]

How about:

IIF([x]="tba", CINT(0), CINT([x]))

Terry M. Hoey

 

[Chance1234]

add another line

x = cint(x)

 

[mollow]

Ahh,

CInt wonderful thanks.
IIF([x]="tba", CINT(0), CINT([x])) didn't work however,

CINT(IIF([x]="tba", 0, [x]) did

Thanks for you help

Mike