Sum of queried records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a new report which will be a job log; displaying information of
jobs that we logged within a date range. What I want to do is have a field at
the end that will sum the number of records that are selected for that date
range. Does that make sense?
For example, if I open this report and I want to know the jobs that we
logged into the database between January 1-January 10, then it will pull up
records 1040-1062, but there is also sub-jobs 1046G, 1021B & 1050G, so my
total number of records is actually 25, not 22. What I'm worried about is
what field do I ask it to sum in order to get sub-jobs AND "regular" jobs
counted? We track in two different ways; there is the auto-number field
called "OrderID" which we don't use anywhere, and there is the "JobNumber"
field which is what we use to actually track jobs. In the above example,
1046G is in the JobNumber field, I don't know what the OrderID would be on
this record.
Any help would be greatly appreciated. I know this is probably something
very simple, but my brain isn't working well today.
Thanks in advance,
Melissa
 
Hello??
I posted this in early MARCH and no one has given me a suggestion/answer
yet? C'mon guys, I know *someone* can do this!!!
Please help me!

Melissa
 
Back
Top