im calling a query from a table field, the query takes two values and adds them together. Party.Adults + Party.Childs
im calling the query from a table called Invoices, in a field called Total, Invoices.Total
Here the problem, i need to get the value of Invoices.Party in the query, so this statement can be fulfilled,
"SELECT Adults, Childs FROM Party WHERE Party = " & Invoices.Party
can you use something like this.Party, the query must know which party' adults and childs its supposed to be adding.