Discuss "access problem" in the Microsoft Access forum.

todd2006 · #1 July 29th, 2008, 09:43 PM

Hi,

I have this query

Code:

strgetrecords =  "SELECT Registration.First_Name, Registration.Last_Name, Points.*, Registration.Perf_Reg_Id From 
Points, Registration where Points.Athlete_Id = 
Registration.Id AND Points.Athlete_Id = " & getid & " order by convert(datetime, Points.Test_Date) desc"

It gives me an error saying
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine does not recognize 'Points.*' as a valid field name or expression.

can someone tell me how to include all the field names in access

todd

Wolffy · #2 July 30th, 2008, 09:34 AM

Hmm...could try [Points].[*]. But if that doesn't work, then I think the error message speaks for itself and you'll need to list every column name from Points in the SELECT. (BTW, I HATE the SELECT * syntax anyway -- only pull the column names you need from the table and it will make understanding the query easier when you revisit the dang thing in 3 months).