I have an excel database that has the following fields:
Account/Charge Per Item/Qty./Amount/Tax/Discount/Cost/Date/Date of Service/Code/Description
I need to create "invoices" for each one based on the account number and date because each account could have more than one invoice but on different dates. Each row lists an item and there could be multiple rows based on how many items were purchased but they will have the same date and same account number for that date.
It's basically a list of rows. Each invoice could consist of 1 or more rows and you can tell based on account number but they are just run on rows. Each row lists an individual invoice line item and the price/tax, etc. There are like 50000 rows so to sort them individual out will take forever I need this by Monday.
I have the database in Excel but I guess I was trying to generate a report by importing it into a table in Access. I've attached to examples of the database as is in Excel (Database) and then sort of an example of how I would like it to be if it's in Excel (test) or if I can make something similiar with a report in Access that would work. I just need to separate each individual invoice based on the account with the line item information and date (and in date order) for 2007.
Ok, so now I understand what you've got. Have you had a look at Subtotals in Excel? At each change in Account Number, SUM the value field. Is that all you need? I am having trouble locking down what it is you want from us?
I was able to figure out. I just wanted a report that separated out all the line items by account number per day (which would have been each invoice). I imported the data into Access and then was able to generate a report after multiple tries that worked! Thank you for you help! And since I am guessing you are a StarTrek Fan, I hope you got to see the new movie!!