Hi,
I am new to this Forum and I am thankful it is here! Anyway, I have uploaded a CSV file from a 3rd party company for our orders. In the file is a field OrderID Number which is duplicated based on the number of items on the sales order. There are no line numbers in the file. I was going to use the item number but about 35% of all orders have duplicate item numbers also, which is fine. I need a way to give each duplicate OrderID number an individual line number. I do not want to use the Access unique ID field and I would like for each 1st line to be either a 0 or a 1.
The Orders, in some instances, have multiple lines. The issue is that I have many Order ID numbers with multiple lines. In the CSV file the columns are all totals so, if I have 3 different items with varying quantities, I have a Total Price column, a Total taxes column and a Net Total column. The issue is, the total column is the total for the entire order, not the line; shipping cost and loss columns are the same way. This results in an overstatement. So if the order total was $120.00 and I had 3 items, $20.00, $30.00 and $40.00 each line would say that the shipping loss is $12.00 and taxes were $18.00 for the entire order, the total column states $18.00 for each line. When I run my query the Order total columns are $120 for order Total, Shipping Loss $36.00 and $54.00.
I would greatly appreciate any help with this. My skills in SQL and VB are very poor and I am not comfortable using them however, I am fairly strong in access. If this was not a repeatable download and append situation, I would use Excel.
Thanks so much and have a great day!