MS Access

Please Respond
User avatar
nidave
Posts: 697
Joined: Wed 19 May, 2004 14.39
Location: Manchester

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
Top
User avatar
Sput
Posts: 7547
Joined: Wed 20 Aug, 2003 19.57

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
Knight knight
Top
User avatar
nidave
Posts: 697
Joined: Wed 19 May, 2004 14.39
Location: Manchester

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.
Top
User avatar
Sput
Posts: 7547
Joined: Wed 20 Aug, 2003 19.57

Gah, they only ever want me for my computer programming abilities, not my body!
Knight knight
Top
Please Respond

Return to “The Lounge”