Metropol

I am designing my first Access database and I have done something monumentaly stupid.
My tables and field names all have spaces in them, this has been file for all my queries so far until I need to do a SQL to select only the latest date.

Is there a way to remove the spaces automatically or can anyone help me with a query to select the latest date.
The query will report on name, test name, test level, test result, date

Is it a problem because the sql misinterprets the space? I think you can do something like enclose the name of the table in ' marks or " marks

Sput wrote:Is it a problem because the sql misinterprets the space? I think you can do something like enclose the name of the table in ' marks or " marks

I have been banging my head against a wall about that all day - could not find the answer on goggle.
I could kiss you

The stupid thing is I would never have made that mistake when doing any web design, No idea why I did it this time.

Gah, they only ever want me for my computer programming abilities, not my body!