Append Query no input field - what do I specify?

[mdavid]

Hi,


I'm trying to populate a new table with an Append Query, some of the fields in the new table come from selecting fields from existing tables.
But I also have new fields which are not selected, but the criteria condition uses existing tables.
An example of what I'm trying to do in query design:

Field: - blank
Table: - blank
Sort: - blank
Append To: NewTable.FieldA
Criteria: IIf(IsNull(InTable.FieldA), InTable.FieldB, InTable.FieldA)

What do I need to specify in Field and Table? Or is the usie of Append Query wrong?

Thanks for any help
David

[pbaldy]

I'm not entirely clear on what you're doing, but I suspect what you have in the criteria should be in the Field argument.

[mdavid]

I've googled a bit further and I understand I need to put the criteria in Field:

Is this correct?

Thanks Paul, just saw your reply confirming.

[pbaldy]

No problem, post back if you're still stuck.