Create a new Column in Access by Query

[vishan_rana]

Hi Masters,

I have a text linked file in access, i want to create a table from link file with a new blank column in last with TEXT intiger.

i did it by Added_Column: (""), it put space in every cell and when i update data in that column by null criteria, it not update, mean not find any NULL cell in that colomn.

Pls help in get this problem resolved

Designed query used for make table not SQL.

Regrds

 

[Norie]

Why don't you use "" for the criteria instead of null?

Or use Added_Column:Null.

 

[vishan_rana]

i used it "Added_Column:Null" but it return column intiger BINARY when table creates. i want that in text with null value