Converting numeric data into Text data

[Stoffman]

I am importing data from a spreadsheet into Access, one of the columns has either null values, Text values or Numeric values (A pain I know). I have an append query linking to a linked table which converts everything else in this spreadsheet to remove nulls and other rubbish data, but for this column I want to convert all Numbers to say "CHQ"

I tried Transaction:IIf(([Trans])>0,"CHQ",([Trans])) As a field name in a query, I assume this doesn't work because of the text records.

Any ideas?

Cheers Chris

 

[earthandfire]

IIf(IsNumeric([Trans]),"CHQ",[Trans])

 

[Stoffman]

Thats great Thanks alot