G goju Registered User. Local time Today, 21:47 Joined Apr 7, 2005 Messages 77 May 5, 2005 #1 any idea whats wrong with the following expression SELECT frmForm.NewID, frmForm.Forename, frmForm.Surename FROM frmForm WHERE (((frmForm.Archive)=No)) ORDER BY frmForm.Surename, frmForm.Surename;
any idea whats wrong with the following expression SELECT frmForm.NewID, frmForm.Forename, frmForm.Surename FROM frmForm WHERE (((frmForm.Archive)=No)) ORDER BY frmForm.Surename, frmForm.Surename;
D DaveJHPT Registered User. Local time Today, 21:47 Joined Mar 17, 2005 Messages 64 May 5, 2005 #2 What is it supposed to be?
Mile-O Back once again... Local time Today, 21:47 Joined Dec 10, 2002 Messages 11,316 May 5, 2005 #3 WHy would you use frm as a prefix for a table? And why order by 'Surename' twice?
G goju Registered User. Local time Today, 21:47 Joined Apr 7, 2005 Messages 77 May 5, 2005 #4 sorry my fault on frm, surname i have taken out once newbie anything else wrong
Mile-O Back once again... Local time Today, 21:47 Joined Dec 10, 2002 Messages 11,316 May 5, 2005 #5 You have a table called frmForm? Do you really? Also, replace No with False.
