Hello all,
Background info for the problem: I have started selling some ebooks on Amazon and I want to do some data analysis. Therefore, I thought that I would put all of the data into an Access database and link to it in Excel spreadsheets, whereafter I can do the analysis. The first screenshot shows how the data looks like in the database. I want to be able to split up the data according to each of the different amazon stores. As you can see in the screenshot the amount of information varies. If there are no sales in a store, it will say "there are no sales during this period", whereas if there are, it will include all of the ebooks that have been sold. If there have not been any ebooks sold, it will not be included. I thought that I would append the data for each store into their respective tables (US, UK, DE etc.). The problem occurs, how do I select all of the ebooks in the specific store and disregard everything else? As you can see there are some blank spaces after all of the information in a store. I thought that maybe I would have to find store name (eg. "Amazon Kindle US Store") loop it somehow and stop until it reaches a blank. But how do I do it exactly?
I am very comfortable creating queries, but I have extremely limited knowledge about SQL.
Screenshot of the situation
Thank you in advance