Adding data to a Query w/o updating the table data

  • Thread starter Thread starter John K
  • Start date Start date
J

John K

I am tiring to create a expression that will allow my to
convert null data into the word "Basic" without update the
table data. The column is a text column in the table with
only one of two values in it, either "null" or comprehens.
I appreciate any help you can give.

John
 
I am tiring to create a expression that will allow my to
convert null data into the word "Basic" without update the
table data. The column is a text column in the table with
only one of two values in it, either "null" or comprehens.
I appreciate any help you can give.

John
Click to expand...
John,
Make a new column in the query.
ColumnName:Nz([FieldName],"Basic")

Look up the Nz() function in Access Help.
 
Thanks for your assistance, however this is giving me an
syntax error for some reason and the help is not helping
me figure why. Do you have any suggestions? Oh Yeah! I
forgot to include the fact that I am working in MS Query
to return data to a excel sheet.
-----Original Message-----
Newcolumn:IIF(ISNULL(yourcolumn),"Basic",[yourcolumn])

-----Original Message-----
I am tiring to create a expression that will allow my to
convert null data into the word "Basic" without update the
table data. The column is a text column in the table with
only one of two values in it, either "null" or comprehens.
I appreciate any help you can give.

John
.
Click to expand...
.
Click to expand...
 
I forgot to mention that I am working in MS Query to
return data to excel. It seems to work in a very similar
manner however I do not seem to have all of the
functionality of Access 2000
-----Original Message-----
I am tiring to create a expression that will allow my to
convert null data into the word "Basic" without update the
table data. The column is a text column in the table with
only one of two values in it, either "null" or comprehens.
I appreciate any help you can give.

John
Click to expand...
John,
Make a new column in the query.
ColumnName:Nz([FieldName],"Basic")

Look up the Nz() function in Access Help.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
.
Click to expand...
 
Back
Top