Expression Builder - Access 2003

[rrosynek]

I have a 2003 Access Database with several tables related in a one to many relationship with a parent I am looking to build a report which evaluates if different users of the table have all entered data properly.

As an example - the parent table creates the customer account number, customer last name and customer ssn. A related table creates all other customer information including address, phone etc., another related table contains information researched on the customer

I am new to expressions but have determined if I wish to conpare two fields from 2 separate tables that should contain the same information, (however the field names are different), I think I would use the if-then-else expression below.

I have built a query with the parent and both tables and used the criteria line in the table A field 1 column to place the expression. I have also tried to move the expression to a new column which creates Expr1: - both have not returned the appropriate responses.

I have also tried building the expression into a control on the report itself separate from the query with no success.

IIf([tableA.field1]=[tableB.field2], "field match", "field input error")

(I am using the expression builder - not skilled in code yet) - any suggestions?

[MMcCarthy]

SELECT ParentTable.Field1,
IIf([ParentTable.field1]=[tableA.field2], "field match", "field input error") As TableAMatch, IIf([ParentTable.field1]=[tableB.field2], "field match", "field input error") As TableBMatch
FROM ((ParentTable LEFT JOIN TableA
ON ParentTable.Field1=TableA.Field2)
LEFT JOIN TableB ON ParentTable.Field1=TableB.Field2)


Try something like this ....

[rrosynek]

SELECT ParentTable.Field1,
IIf([ParentTable.field1]=[tableA.field2], "field match", "field input error") As TableAMatch, IIf([ParentTable.field1]=[tableB.field2], "field match", "field input error") As TableBMatch
FROM ((ParentTable LEFT JOIN TableA
ON ParentTable.Field1=TableA.Field2)
LEFT JOIN TableB ON ParentTable.Field1=TableB.Field2)


Try something like this ....

Thanks - where would I attach this statement - to a text box control in a report or to a new column in a query or to a criteria line in a column - trying to stay within boundaries of my knowledge of access expression builder feature/wizard

again - thanks

[MMcCarthy]

Thanks - where would I attach this statement - to a text box control in a report or to a new column in a query or to a criteria line in a column - trying to stay within boundaries of my knowledge of access expression builder feature/wizard

again - thanks

I meant for you to use this as the Record Source for a new report which is what you said you wanted.