Creating a Querry using a macro

[alexaronson]

Hello,

I am looking for a little help. I have 50 tables in a file that I want to append to another table in particular file. I do not need all the data, just selected data summed up. The fields I want are Item, Month, Year, Qty all grouped together with QTY summed.

Any help will be greatly appreciative.

Thanks
Alex in Memphis, TN

 

[MyBoo]

If you did what I suggested, while you waited for me to reply, then you should have one primary table now, the database should be compacted and space recovered.

As this should have been a one-time deal as you should try avoiding this same situation as you go forward, what am I missing?