Creating a summary report

[slenish]

Hi,

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

[mseo]

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

[slenish]

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

[mseo]

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

[slenish]

@mseo
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