I am creating an invoice that will have the business' information at the top, Invoice #, Date/Time of sale, customer information in the middle, and the purchase items at the bottom. What I want to be able to do is create a database to query lots of data later on by searching for a customer name or type of item. So in order to use Microsoft Access, I need to be able to put the data into individual records. So I imagine if the customer purchases/trades 3 items, I would need to have each item in its own row, but also include the invoice #, Date/Time, Customer information to the first cells in the row. So I am getting stuck, because the number of items will change with every customer. How do I proceed with this?
What I am thinking is that I have to create an object variable to classify the information that will be the same (Invoice #, Date/Time, Customer Info, Business info) - Let's call this WSC worksheet customer
and another variable for the item information. - call this WSI worksheet item
I need to type some sort of if statement to search the 8 possible rows a20:f27 on the invoice for data. If WSI is found, place that data in row ?, column ? then place the WSC in the cells prior.
What I am thinking is that I have to create an object variable to classify the information that will be the same (Invoice #, Date/Time, Customer Info, Business info) - Let's call this WSC worksheet customer
and another variable for the item information. - call this WSI worksheet item
I need to type some sort of if statement to search the 8 possible rows a20:f27 on the invoice for data. If WSI is found, place that data in row ?, column ? then place the WSC in the cells prior.