I am creating a report which is based on a table of customer survey results all based on a scale of 0 to 9. I need to create a report that allows for month vs month comparison. I am not sure how to organize the report/query properly. Can anybody help me get started?
Month by Month reports (1 Viewer)
- Thread starter mlamont
- Start date
sambo
Registered User.
- Local time
- Yesterday, 20:25
- Joined
- Aug 29, 2002
- Messages
- 289
What does you table structure look like? If you build the tables correctly you should be able to do whatever you want... Sums, Averages, Outliers, Max/Min, the whole bit.
Graphs would be good to use also.
You're going to have to be more specific..
Do you have a month table? Surveyee Table? Questions Table? Or is it all in one big (flat) table?
Graphs would be good to use also.
You're going to have to be more specific..
Do you have a month table? Surveyee Table? Questions Table? Or is it all in one big (flat) table?
sambo
Registered User.
- Local time
- Yesterday, 20:25
- Joined
- Aug 29, 2002
- Messages
- 289
If you are going to just use one table, then you really will want to switch over to Excel.
But... If you really want to make Access work for you, study up on Normalization. This is the method of expelling duplicate data from your tables.
Check out the latter half of this report.
If you just to have the time or interest to learn about Normalization, then I would suggest going w/ MS Excel.
But... If you really want to make Access work for you, study up on Normalization. This is the method of expelling duplicate data from your tables.
Check out the latter half of this report.
If you just to have the time or interest to learn about Normalization, then I would suggest going w/ MS Excel.
