Im not sure how to ask this question so I'll provide as much info as I can.
I have a database which was given to me as individual tables for each year, Im using union to combine them. I have a form that allows people to make selections based on things like location, year, types, ect. It then dynamicaly creates a query to select those things and then combines it with data from another table, which then gets set to a report. What i would like to do is check if all of the data is the same then show one record for each location where years had all the same data say 2008-2015 rather than as it is now displaying each record as a seperate page. There are a few things to check, 30+ or so. Im not sure where to start this. Should this be done in SQL or can I do it as part of the report after I have the data, or should I do this first and then send the new data to the report?
Example:
Records: LocationA , Year1, thing1, thing2, thing3, thing...
LocationA , Year2, thing1, thing2, thing3, thing...
LocationA , Year3, thing1, Sprocket2, thing3, thing...
Output(of sorts):
LocationA for Year(s) Year1-Year2, thing1, thing2, thing3, thing...
LocationA , Year3, thing1, Sprocket2, thing3, thing...
I've tried grouping but i dont think its complex enough for what im wanting to do.
I could do code but im not very familiar with access, and where i should put it in this case.
I have a database which was given to me as individual tables for each year, Im using union to combine them. I have a form that allows people to make selections based on things like location, year, types, ect. It then dynamicaly creates a query to select those things and then combines it with data from another table, which then gets set to a report. What i would like to do is check if all of the data is the same then show one record for each location where years had all the same data say 2008-2015 rather than as it is now displaying each record as a seperate page. There are a few things to check, 30+ or so. Im not sure where to start this. Should this be done in SQL or can I do it as part of the report after I have the data, or should I do this first and then send the new data to the report?
Example:
Records: LocationA , Year1, thing1, thing2, thing3, thing...
LocationA , Year2, thing1, thing2, thing3, thing...
LocationA , Year3, thing1, Sprocket2, thing3, thing...
Output(of sorts):
LocationA for Year(s) Year1-Year2, thing1, thing2, thing3, thing...
LocationA , Year3, thing1, Sprocket2, thing3, thing...
I've tried grouping but i dont think its complex enough for what im wanting to do.
I could do code but im not very familiar with access, and where i should put it in this case.