Replies

The select statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. Is there any other way I can do this so that it would ask for an x number of records. Thanks. Robin

I didn’t create a new query – I have a query set up with 3 tables. I have an ID field for names and I want to be able to select x number of names at random. Hope I am explaining this ok.. So I typed into the SQL screen in the query – where it starts
SELECT TOP [HOW MANY?], ATA.Surname, ATA.Title, ATA.Prename, ATA.EmailAddress, ATA.HomeEmailAddress, ATA_Committee.Lcomm, Committee.TabComm, ATA.ID AS [Count]
FROM (ATA INNER JOIN ATA_Committee ON ATA.ID = ATA_Committee.ID) INNER JOIN Committee ON ATA_Committee.Lcomm = Committee.Code;

Then I tried typing in the same thing in the criteria row.
Thanks

Where do I enter the syntax ? I tried entering it in the SQL screen then in the criteria row and it just give me an error. Can you give me any other suggestions. Thank you for your time.