Search results

I have 6 files per region x 9 regions = 54 files. 5 out of the 6 files has monthly data with the same period structure. I have a simple Query that pulls the common fields and combines it into 1 Table. (I send this data table out in excel with a simple pivot, combines huge excel files files...

Hi all, I need a simple query or queries that will do the following. First summarize the data by company name (Easy Part) then calculate the monthly value from 2 year to date values (Date field is text). I am going to append this list to another table to give me a monthly calculation by...