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:
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?
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:
Code:
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?