View Single Post
  #12  
Old November 9th, 2006, 07:43 PM posted to microsoft.public.access.queries
[email protected]
external usenet poster
 
Posts: 10
Default #Error when using IIF statement in a query


KARL DEWEY wrote:
Your field [Quote_ELC_Type] would be a text field instead of a number field.



Yes, absolutely. I wish the obvious sometimes would come easier. It
all makes perfect sense now.
Would it be better practice to make this field a number field instead
of a text field? My reason for making it a text field was that it will
not be included into any calculations.

TIA.
Regards,
A. Crawford