03-22-2017 09:17 PM
5. Edit the Sales Query from the US Sales.
Not sure where US Sales comes from but...
I am stuck on step 5 and 6. From AccessDB query1, I'm attempting to append International Sales to Sales in query editor. When I attempt to Append Queries the only options shown are the other tables within the AccessDB.
Thanks for your help.
03-22-2017 11:40 PM - edited 03-23-2017 12:11 AM
Firstly, US Sales table means Sales table, so you can edit it to continue to do next step.
Secondly, when you select Sales table in Queries, you can use append funtion to append International Sales.
I get the result as below:
02-26-2018 02:35 AM
It is been mentioned as US sales, but they are actually referring to the previous "Sales" table itself.
So u just have to append the Sales table with the International Sales table and are good to go.