By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,516 Members | 1,107 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,516 IT Pros & Developers. It's quick & easy.

Creating a summary report

P: 283

Im having some trouble creating a report to print data off of my table. I want to create a summary report that will take a group of numbers and total them up. I have tried using the general sum function along with grouping but im still not getting the results I want.

In more detail. I want to be able to type in a certain date range say from 4/1/10 to 4/15/10 and then and ID number like 10001. Then when the report comes up it will take the column NumOfErr and total how many there are for that ID number, and print the result. How would I go about creating this?

Thanks in advance
Apr 7 '10 #1
Share this Question
Share on Google+
4 Replies

P: 181
what exactly do you need to do , open the report for data range of specific ID and between two dates or getting the sum of this data range
Apr 7 '10 #2

P: 283
What im trying to do is make is so you can type in a date range and an ID number and it will pull up a total based on the date and ID number for number of errors.

So for example I want to pull up the month of April, and check to see how many erorrs ID number 12345 did. On my table I know i need the query to look at all the records with ID 12345 and start counting all of the errors for all the days of the month of April, and then print that total.

so the report would look like

4/1-4/30 IDNum: 11111 Total number of Errors 20

Appreciate the help
Apr 7 '10 #3

P: 181
hi, slenish
As I understood from your question I made a query to count the number of errors as entered in the table you can try the report attached to the post using ID: 21111 , from: 1/1/2010, to:4/30/2010
if you want to make sure that it is work fine insert new data into the table and try it
hope this help
Apr 8 '10 #4

P: 283
Hi Mseo,

Well its not quite what I was trying to do but its on the right path. I actually figured out what the problem was and why it wasnt working. I forgot to set my Date field to a where expression which made everything work right. Really appreciate the help :D
Apr 10 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.