[AccessD] Painted into a corner

Drew Wutka DWUTKA at marlow.com
Tue Mar 11 13:19:00 CST 2003


John, just use a Union query.  A union query in Access must be written in
SQL, but it's pretty simple.

Let's say you had this table:

tblClients:
FirstName
LastName

and this table:

tblPersonnel:
FirstName
LastName

Now, let's say we had this data:

tblClients:
FirstName    LastName
Bob		Smith
George	Blue
Harry		Jones

tblPersonnel:
FirstName 	LastName
John		Jacobs
Greg		Myst
Anna		Grant

Okay, now you want a query to show both your clients and your personnel in
the same fields.

To show just the clients, this SQL would work:

Select FirstName, LastName


More information about the AccessD mailing list