Queries Updating Tables

[steve1111]

hello,

I know that i can edit contents in a single table query and it will update the data in the underlying table, but how do i gain the ability to change data in a query when 3 tables are involved? - i am a beginner so i need to try and do this without code.

thanks for any tips

 

[steve1111]

I did have the totals showing, so when i removed them, i can now edit the query however, the rest of the query still filters except the reconcile does not show only the false.

thanks

 

[steve1111]

Thanks so much Pat, perfect!