Jun 27 2008, 02:09 PM
I'm using an IIf statement in a calculated field in a query, and the result won't give the option of changing the format of the field. This is the statement:
FOB is a text field and FOBCost is a currency field. Is there any way to fix this so that the result can be set to currency as well?
Jun 27 2008, 02:11 PM
Try dropping the quotes around the zero so it's not treated as text.
Jun 27 2008, 02:28 PM
If Pauls suggestion doesn't work, maybe...........
Jun 27 2008, 02:59 PM
Dropping the quotes worked great!
Thank you for your fast responses!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here