M
mktg@wfi
I'm creating a master list of data in a table. I started with a make table
qry - creating header info for all columns I'll need but leaving certain
columns blank as place holders. I then created an update qry to add data to
the blank columns by writing an Iif statement. But my outcomes are always
text and I need them to be numbers. I tried using "Inactive Ind: Null" and
"Inactive Ind: """ for the blank columns when making the table. But I
continue to get errors when using "Null" b/c it makes the columns binary or
text when I use "" in the placeholder columns.
I'm self-taught and don't know sql.
qry - creating header info for all columns I'll need but leaving certain
columns blank as place holders. I then created an update qry to add data to
the blank columns by writing an Iif statement. But my outcomes are always
text and I need them to be numbers. I tried using "Inactive Ind: Null" and
"Inactive Ind: """ for the blank columns when making the table. But I
continue to get errors when using "Null" b/c it makes the columns binary or
text when I use "" in the placeholder columns.
I'm self-taught and don't know sql.