Issues With Reporting

[Hayesc]

I'm creating a database to track call drivers or reasons for customers calling in. All of this information is selected via combo boxes and stored in a table. I have a query to pull the data and a form that lets you select date parameters to filter the time you want the query to pull. Here is the problem I have a report that displays the count and percentage of the data selected from the query, but I also need to display and calculate data from the week before the time selected and also what the percentage the call driver is YTD. Does anyone have suggestions on how I could do this?

 

[HiTechCoach]

I normally handle this with sub reports for the different time periods.

If it must be in a single query result then use I use multiple queries and/or sub queries.

To give you specificss on how to do it with your database we will need to know the table structures.

 

[Hayesc]

I have a 2 tables one that lists category and the other the sub category that populate into the combo boxes. The options that are selected are on a form that stores data into an entry table. The query associated with the report pulls it's data from this table. I hope that helps if not I can always try linking the database to my next post.

 

[HiTechCoach]

The simplest way will probably be to start out making separate saved queries for the different time periods.

You may be able to make an additional query that uses the other queries as the data source (like tables) and join the data together

Or you could use a sub report for each time period.

 

[Hayesc]

I tried linking the 3 seperate queries together via 1 query and got the erroe message category could mean one then more thing in the table. If I did run it via a subquery how would I get it to display on the report?

 

[HiTechCoach]

I tried linking the 3 seperate queries together via 1 query and got the erroe message category could mean one then more thing in the table.

I don't understand what this means.

As you saying that main table is using the same look up table with multiple fields? Is this is true then this is an indication of repeating fields. Repeating fields are a red flag for design issues that violates the rules of data normalization.

 

[HiTechCoach]

It would help to see your table structures.

There are some tools some member here came up that may assist you in posting examples: http://www.mrexcel.com/forum/showthread.php?t=253692