Help needed with "and=" statement

[newtoAccess]

What am I doing wrong in this query statement?

I am doing a test to confirm that the data is the same in three tables.
All three are linked by IDNo.

Field name: GradeGood:
if "Table Data Detail. Field Grade" equals
"Table for Search.field Grade" and also equals
"Table Data. Field Grade"
set field "Good" else "No

The statement "and = [Table_Data]![Grade]" keeps disappearing from the statement after running it.



The statement I am using is this:
GradeGood: IIf([Table_Data_Details]![Grade]=[Table_for search]![Grade] And = [Table_Data]![Grade] ,"Good","NO")

[jzwp11]

You have to repeat the the field name in each AND part of the clause

GradeGood: IIf([Table_Data_Details].[Grade]=[Table_for search].[Grade] And Table_Data_Details].[Grade] = [Table_Data].[Grade] ,"Good","NO")

Out of curiosity, why do you have the same information in multiple tables?

[newtoAccess]

In my first table, I have the main data entry from a form, The second is where I split the original data in to other fields.

The third is a play area so I don't mess up the first two.

When I play, experiment, I want to check from time to time to ensure that specific data has not changed and is still aligned up with the ID field.

[jzwp11]

Having the same info in multiple tables violates good database practices. In your main data entry form, either split the data into two controls (and two fields) or split it as it is being entered (via code). If you have a primary key field, you would use that and only that value to link to related tables. I guess we need to understand what your application is trying to do to be better able to help you.

[newtoAccess]

This works for now and is all most complete.
Data is being generated for reports that will end near the end of the month.

I will think it over better if there is a next time.