Well, the total short per size is in the line already, the last is just the total for the size, I think even that is negotiable as it can be summed later.
Well, the total short per size is in the line already, the last is just the total for the size, I think even that is negotiable as it can be summed later.
OK, I'll see what I can come up with.
I think this will be close. At least it works with the test file you posted. Have fun.
I'm still checking for accuracy but from what I can tell its working great. Thanks a bunch! Now I need to read through the query and figure out how you did it.
I only put the "dump the data" code so the table would be empty when you opened the db. That way you had to know that it was the code that was filling the table. Why do you need to export the data to a spreadsheet? You could probably do everything in Access.It appears to be working great! I really appreciate your help. Quick question, there is a private sub "Form_Unload" to dro the contents of the table, would it adversely affect anything if I had it export to a spreadsheet prior to dumping the data?
Portability, the end result is sent down the line.
I understand. Thanks.
Were you able to resolve the new issue that came up?