Getting Totals

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

Guest

I have a DB with a bunch of records of PCs, each PC has a
field that lists the VScan version. I need to create a
report to total-up all the versions, but I have no clue
how to do it.

I've created a query that I can pass a parameter to which
will give me the total number of THAT version, I was
thinking of assigning the query to each textbox and
passing each the Vscan version I was looking for. However
I don't know if thats even possible, or where to do it.
When I run the report it keeps prompting me for the
parameter (which I dont want)
 
You could create a report grouped by the Vscan Version,
and in the group footer you can create a text box with
=Count([NameOfVariable])
Hope this helps
Fons
 
I have a DB with a bunch of records of PCs, each PC has a
field that lists the VScan version. I need to create a
report to total-up all the versions, but I have no clue
how to do it.

I've created a query that I can pass a parameter to which
will give me the total number of THAT version, I was
thinking of assigning the query to each textbox and
passing each the Vscan version I was looking for. However
I don't know if thats even possible, or where to do it.
When I run the report it keeps prompting me for the
parameter (which I dont want)
Click to expand...


Base the report on a Totals type query:

SELECT version, Count(*) As CountOfVersion
FROM thetable
GROUP BY version

After that, the report should be pretty simple.
 
Back
Top