Search results

The field had no value in it like $0.00, that's why it was not picking up.... thanks again! I never worked in access so this project is killing me, but its good to learn something new:)

OMG I figured it out! Thank you so much!!!!!!

I think something is wrong with my data which I imported from excel. The formula works when I open a new access doc and just enter data manually, but it doesn't work with imported data. I have 6k rows so I wouldn't be able to enter everything manually. Do you have an idea how to fix the problem?

Expr1: IIf([Historical Value]=0,[Acquired Value],[Historical Value])

Its not working;( It only returns value from Historical Value field if it doesn't equal 0, but not picking up value from Acquired Value field when historical does =0.

I need help:( I need to calculate field based on the following criteria: If Historical Value=0, then return $value from field acquired value, if not return $value from historical value field. How can I do that?