Kevin123456
Technical User
Hi,
I have an MS Access database with the table name 'All'. When I try to select it in a query (select * from all) then I get a syntax error, presumably 'All' is a reserved keyword. If I rename the table 'Alls' then the select is no problem. Ideally I would like to avoid having to rename the table as following on from this I have two fields in the table called 'Group' and 'Year Group'. When doing an order by 'Group' works with no problems but the field 'Year Group' doesn't sort the data. They are both text fields of 50 characters in length. Is it possible to select from the 'All' table and order by the 'Year Group' field?
Any help gratefully appreciated.
I have an MS Access database with the table name 'All'. When I try to select it in a query (select * from all) then I get a syntax error, presumably 'All' is a reserved keyword. If I rename the table 'Alls' then the select is no problem. Ideally I would like to avoid having to rename the table as following on from this I have two fields in the table called 'Group' and 'Year Group'. When doing an order by 'Group' works with no problems but the field 'Year Group' doesn't sort the data. They are both text fields of 50 characters in length. Is it possible to select from the 'All' table and order by the 'Year Group' field?
Any help gratefully appreciated.