There are also 3rd party tools out there that can ensure that the name is
changed everywhere. They can also just do finds for you.
Look for tools such as Rick Fisher's Find And Replace
http://www.rickworld.com/products.html or Speed
Ferret from Black Moshannon http://www.moshannon.com/
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Chris" <Ch...@discussions.microsoft.com> wrote in message
news:114CCE9B-CE3D-4A53...@microsoft.com...
Select e1.employeeName as WorkerName, e2.employeeName as SupervisorName
From tblemployee as e1 Inner Join tblemployee as e2 On e1.SupervisorID =
e2.EmployeeID;
To do this in the grid,
WorkerName:EmployeeName -- SupervisorName:EmployeeName
e1 -- e2
Separate the alias name from the field name with a colon.
"Chris" <Ch...@discussions.microsoft.com> wrote in message
news:114CCE9B-CE3D-4A53...@microsoft.com...