I have a table that lists job number/part number/quantity and I use a counter field to keep this data in the order that it was enter into the table for reports. Some jobs have multiple entries of the same part number and quantity. I use a query to sort all of the part number for a job and a total to combine the quantities for similar part numbers. This creates a list of unique mark numbers and totals the quantities.
I would like to keep the order of the part numbers in he same order as they were entered. Is there some way I can include my counter in the total query to get this done?
I understand some of the consecutive numbers will drop out but that is not an issue. Want to keep same order for reporting.
Thanks,
Greg