I would like to create a field in one Access table that is based on the criteria of another Access table.
The field would require an if statement and an or statement.
Something like this:
If [table1].[APPLES] or [table1].[GRAPES] is greater than 0
[table2].[FRUITCOUNT] = [table1].[FRUITCOUNT]
Any help would be greatly appreciated!