Search results

I want to update Override field in Table 2 using Qty column in Table 1. How do I write this query? Thank you!!! :confused: Please see attached tables.

I have a report based off of table. I have a query based of off same table that does count on one of the columns. I want to display this count on the report. I added a text box on the top of the report and try to link it to the query but I get an #ERROR. Can someone help me what I am doing...

Table 1 Item No A B C D E Table 2 Item No Sales A $10 B $20 C $30 I want to be able to select all items from Table 1 and matching records from Table 2. I want the result to look like this: Item No Sales A $10 B $20 C $30 D...