Hello

i ve got three tables table 1 table 2 table 3 . I need to multiply the fields of table 1 with table 2 . To do that i use the following syntax Expr1: ([table1]*[table2]) and works fine . How can i restict this formula to a specific field on table 3 . To clarify this table1 =oranges table2 = 1 pound and table3 =customers .

i have to develop a way to find the sum of all orders(table1Xtable2) of specific customer . John exists many times in table 3 and many oranges have been ordered by him many times .

Expr1: Sum([table1]*[table2])

where tabl3.field like 'samefield' this is a wrong statement but this this what im trying to do

table3 table2 table1
john 1 3
john 1 4
john 1 5
query should produce 12