Workaround table with spaces in column names (1 Viewer)

[nfk]

Hi,

I got a query on Access 2010 that keeps popping up a window asking for a parameter, I'm guessing is because the brilliant developer thought I would be a good idea to use spaces on the column names:

SELECT 
0 AS timetable,
Switch(
LOCATION = "WEST", 1,
LOCATION = "CENTRE", 2,
LOCATION = "EAST", 3,
LOCATION = "NORTH", 4,
LOCATION = NULL, 5
) AS location,
[VEHICLE NAME] AS title,
[VEHICLE TYPE] AS subtitle,
[EST TIME IN] AS start,
[EST TIME OUT] AS end,
[DATE IN] AS start_date,
[DATE OUT] AS end_date,
CUSTOMER_NAME AS description

FROM [VEHICLE BOOKINGS TABLE]

WHERE LOCATION > "";

When trying to display as results table it would ask you for parameter [VEHICLE NAME], whats weird is that its only that parameter thats asking when there's more column titles between brackets on the query.

Any ideas?

 

[The_Doc_Man]

This always occurs when there is a spelling difference between what was declared and what was referenced. I would consider checking that you don't have an extra space in the reference (or in the table definition).

If you had a way to do it, I would also SERIOUSLY consider editing that dog ASAP to get rid of the spaces, but that's just me.

 

[jdraw]

I agree with TheDocMan. It might be helpful to show the table design for
[VEHICLE BOOKINGS TABLE].