Using SQL to sort data
Posted on 2008-06-09
I have an mdb file that has two feilds in a table. Invoice Summary, and Invoice Date. I would like to be able to sort through the data and return a series of tables to be used for another purpose. I need to be able to have a table with monthly data, quarterly data, and complete fiscal data. I also need the same tables with the same parameters, except with prior year data instead of current year. Any help would be greatly appreciated!