Field = blankl, Show Value from Other Field?

[excellenthelp]

Hello Accessers,

I am attempting to build a query where if one field is blank, the query can continue to include the data from the next field instead of excluding it in the results.

The two tables and a query I am attempting to create a query from are:

TABLE tblAssignment:
ID (PK)
AssignmentDescrip
AMID (fk)


DIVID (fk)

TABLE tblDivision
ID (PK)
Division

QUERY qrySupportName:
ID
EmployeeName
DIVID (fk)

I am building another query based on these three above to create a report where I could break down the assignments by DIVID from tblAssignment.

The problem is that not every record have AMID but DIVID should be all filled. However, I do not want to manually select which division for every record, for when I select an AMID, it should autofill the DIVID according to the selection I made for AMID. For those without AMID, I would then select the division.

How may I achieve this?

Thanks...

[June7]

Maybe:

Nz([AMID], [DIVID])

[excellenthelp]

June7,

Thanks for the tip- where do I put that in?

[June7]

I am not sure, perhaps in qrySupportName on the Field row. This will create a field in the query.