AnsweredAssumed Answered

Help making reports

Question asked by TonyReis on Nov 6, 2013
Latest reply on Nov 11, 2013 by philmodjunk

Title

Help making reports

Post

     I need some help creating reports for this database that I have made. I have attached it. I need to be able to create a report that is able to group by month of entry. I need to tell me the total number of records created that month as well. And then break it down even more by Manufacture, Device, warranty status. Including the total revenue for that month.  I figure that the last 3 will just be a calculation formula.  They are also value lists so I should be able to group them by the respected values. I just can't figure out how to do this or how to group them by months.

                    Sorry, I just want to be more detailed in what I would like it to do.

                    I would like the repair to show me the month, total recorded created that month in number format. The record totals for that month broken down by different manufacture, devices. Then the number of warranty records and the total for revenue income.

                    So something looks like this:

                     

                    October  115 records

                    Apple repairs 35 : warranty 20 : out of warranty 15 : Revenue $1500

                    Ipads 5 : imacs 16 : macbooks 9 : Ipods 5

                    And so on for every different manufacture and start again for a next month.

                    When I have tried I get a list for every day of the month.

                    To be more detailed Manufacture and devices are a value list. warranty is radio button set

                    Is there a way to break it down like this?

     Any help would be appreciated

2013-11-06_120103.jpg

Outcomes