G goju Registered User. Local time Today, 23:30 Joined Apr 7, 2005 Messages 77 Apr 15, 2005 #1 trying to use this as a source code to look up numbers and records. it returns a syntax error. SELECT qryForForm.EKGB Number, FROM qryForForm ORDER BY qryForForm.EKGB Number; any ideas???
trying to use this as a source code to look up numbers and records. it returns a syntax error. SELECT qryForForm.EKGB Number, FROM qryForForm ORDER BY qryForForm.EKGB Number; any ideas???
KenHigg Registered User Local time Today, 18:30 Joined Jun 9, 2004 Messages 13,327 Apr 15, 2005 #2 If 'EKGB Number' is the name of a field, go back and fix it there by leaving the spaces out of your field names.
If 'EKGB Number' is the name of a field, go back and fix it there by leaving the spaces out of your field names.
Mile-O Back once again... Local time Today, 23:30 Joined Dec 10, 2002 Messages 11,316 Apr 15, 2005 #3 Number, FROM Click to expand... Remove the comma. And enclose field and table names with square brackets. SELECT [qryForForm].[EKGB Number] FROM [qryForForm] ORDER BY [qryForForm].[EKGB Number]; Maybe find a website detailing SQL.
Number, FROM Click to expand... Remove the comma. And enclose field and table names with square brackets. SELECT [qryForForm].[EKGB Number] FROM [qryForForm] ORDER BY [qryForForm].[EKGB Number]; Maybe find a website detailing SQL.
G goju Registered User. Local time Today, 23:30 Joined Apr 7, 2005 Messages 77 Apr 15, 2005 #4 Ta thank you for your paitents this works (I think) but doesnt change the rest of the data. just the serial numbers. the best way to learn is making mistakes ( I seem to make a lot of them)
Ta thank you for your paitents this works (I think) but doesnt change the rest of the data. just the serial numbers. the best way to learn is making mistakes ( I seem to make a lot of them)
