Maybe this is easy but can't find how....
I have two tables:
Table_A basic fields:
Table_B basic fields
- Calc_Field (numeric, stored)
The two tables are related as
In Table_B I have already flagged duplicates with a self-join and a specific field:
Record_Duplicate = If (Record_ID = Table_B_duplicate::Record_ID; ""; 1)
In Table_A, I need to show a chart of values from Table_B::Calc_Field only for non-duplicates records
Anyone may help please ?