jet-sql

How to give where condition in the select query?

How to give where condition in the select query? ACCESS 2003 MY Query SELECT RECORDNO, PERSONID, EMPNAME, TITLENAME, DEPARTMENT, NATION, CARDEVENTDATE, INTIME, OUTTIME, (select TOP 1 F1.CARDEVENTDATE from tmp_cardevent as F1 where F1.RECORDNO < F2.RECORDNO AND F1.PERSONID = F2.PERSONID order by F1.RECORDNO DESC, F1.PERSONID DESC) A...

JET SQL for Access 2003

Hello all, I have the following SQL statement: Select Choose(1,Orders.Employee, Orders.Customer) as Name1, Choose(2,Orders.Employee, Orders.Customer) as Name2, [Shipped Date] FROM Orders; However, the field "[Shipped Date]" has a space in it and hence why I have put square brackets around it. The problem is, in SQL view, it seems to...