|
| |
|
|
yks625
Posts: 1
Joined: 3/21/2007
Status: offline
 |
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
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 