query using 1 table vs 2 tables

[TiffBrassy]

I think this is an easy one and my brain just isn't working yet. I have 2 queries. In the first query I have a table with DEPT field and one of the query fields says the following: New Account: GetElement([DEPT],1,"*") which is telling it to give me the value in the DEPT field that is in front of the asterick. In this same query I have another field that says the following: VALIDATION7: IIf([New Account] Is Null,"Review Missing New Account Code") So when I run this it works fine.

The second query with 2 tables with the same fields when I run this it wants me to Enter the "New Account". Only one table has DEPT.

What am I missing????

 

[GinaWhipp]

Not sure I'm understanind but it sounds like the table that contains the field *New Account* is not in the second query. Is that true?