G
Guest
I have an calculated field that is supposed to be adding three fields
together, however, they are being concatenated instead.
The fields looks something like this:
Room_Rental: IIf(nz([ACTRENTAL])=0,NZ([RENTAL]),NZ([ACTRENTAL]))
and the calculated field is like this:
Total_Revenue:
(nz([Food])+nz([Beverage])+nz([Other])+nz([Res])+nz([Room_Rental]))
The query result for a particular record would look like this:
60005000100
where Food=6000, Beverage=500, Other=0, and Res=100.
I think I am having problems with my data types but don't know how to
resolve them.
together, however, they are being concatenated instead.
The fields looks something like this:
Room_Rental: IIf(nz([ACTRENTAL])=0,NZ([RENTAL]),NZ([ACTRENTAL]))
and the calculated field is like this:
Total_Revenue:
(nz([Food])+nz([Beverage])+nz([Other])+nz([Res])+nz([Room_Rental]))
The query result for a particular record would look like this:
60005000100
where Food=6000, Beverage=500, Other=0, and Res=100.
I think I am having problems with my data types but don't know how to
resolve them.