[thelist] Access JET SQL problem

rudy r937 at interlog.com
Fri Jan 25 10:09:00 CST 2002


>SELECT [NAME], [MAWB#] FROM [main];

hi jay

> (1) How can I check that "MAWB#" is the actual column name?

this would be one of those very rare times when it's okay to run

    select * from main

> (2) How can I select this if it contains the # character,
> and is this what is really causing my problem?

with that special character in the column name, you must always code the
square brackets


rudy




More information about the thelist mailing list