L
Lynn A.
I receive two files at the end of each month.
One called "Tracking" has a list of all changes to all invoices (some
invoices have actually been invoiced and others are still in
progress), the other just has the invoices called "Invoices" (just the
invoices that have been finalized). These are sent automatically at
the end of the month from an SQL server.
For some reason the invoices file is now coming with duplicates in it.
I have asked the people who send this to me to remove the duplicates
but they say they can't change the SQL on their end. (I thought SQL
is supposed to be flexible enough to make changes to queries?????). I
thought I could just delete the duplicate invoice numbers, but found
out that the values are not equal in some cases so I have to go to the
"Tracking" spreadsheet to find the most recent change and keep that
copy of the Invoice.
The question:
Is it possible to compare the most recent change in the "Tracking"
spreadsheet to the "Invoices" spreadsheet, then delete the duplicate
records in the "Invoices" spreadsheet.
Currently, I delete all the extra changes in "Tracking" so that I am
only seeing the most recent of Invoice changes. Then I am going
Invoice Number by Invoice Number and comparing values to the
"Invoices". Once I have no duplicates in the "Invoices" file, it gets
uploaded into Access for further manipulation. The only reason I
noticed this is because in Access, some of the Invoice values were
doubled because the invoices were "summed" during the upload phase in
Access.
Any suggestions would be great.
Thanks, Lynn
One called "Tracking" has a list of all changes to all invoices (some
invoices have actually been invoiced and others are still in
progress), the other just has the invoices called "Invoices" (just the
invoices that have been finalized). These are sent automatically at
the end of the month from an SQL server.
For some reason the invoices file is now coming with duplicates in it.
I have asked the people who send this to me to remove the duplicates
but they say they can't change the SQL on their end. (I thought SQL
is supposed to be flexible enough to make changes to queries?????). I
thought I could just delete the duplicate invoice numbers, but found
out that the values are not equal in some cases so I have to go to the
"Tracking" spreadsheet to find the most recent change and keep that
copy of the Invoice.
The question:
Is it possible to compare the most recent change in the "Tracking"
spreadsheet to the "Invoices" spreadsheet, then delete the duplicate
records in the "Invoices" spreadsheet.
Currently, I delete all the extra changes in "Tracking" so that I am
only seeing the most recent of Invoice changes. Then I am going
Invoice Number by Invoice Number and comparing values to the
"Invoices". Once I have no duplicates in the "Invoices" file, it gets
uploaded into Access for further manipulation. The only reason I
noticed this is because in Access, some of the Invoice values were
doubled because the invoices were "summed" during the upload phase in
Access.
Any suggestions would be great.
Thanks, Lynn