|
yks625 -> Too few Parameters Expected 1 (3/21/2007 14:48:14)
|
I am running advanced sql in DW8 using access for the first time.
The sql is taken from Access, but when put in recordset gives the error above.
The codes are
SELECT [210307].[Hol Ref], [210307].Destination, [210307].Field3, [210307].Field4, [210307].[Dept Date], [210307].Length, [210307].Airport, [210307].[Dept Time], [210307].Airline, [210307].[Flight No], [210307].[Dest Code], [210307].Price, [210307].[Hol Code], [210307].[Resort Name], [210307].[Room Type], [210307].[No of Nights], [210307].Board, [210307].Rating
FROM 210307
WHERE ((([210307].[Dest Code])="ANU"));
Help
|
|
|
|
