I'm guessing that some of these queries draw from the same tables, or tables
that have a LastName field. In the lower level query, you can alias the
LastName by typing another name and colon in the Field row before the field
Then in the upper query (the one that uses that one, use Surname instead.
Since the names are different, it should solve JET's confusion about which
one is intended.
If that doesn't work, post the SQL statement. If qselEmplActive is also a
query, post that one too.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.