counting or summing non-numeric fields

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

Guest

hello
I'm making a database of computers called 'Workstations' and one of my
fields is called PCType and has 2 lookup values, 'Desktop' and 'Laptop'. Now
I'd like to show the total number of Desktops and total number of Laptops in
my table but not sure the best way to do it. Any suggestions?

thanks in advance
IC
 
You need to create an aggregate (or Totals) query. Create a standard Select
query adding the PCType field twice, then push the Sigma (Greek E) button to
convert it to a totals query. You'll want to set the Totals row of the
first PCType field to Group and the totals row of the other field to Count.


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Create a new query in design view.

Select the table with this data.

Select your ID field and the PCType field.

Click on the 'sigma' (Totals) button.

Keep "GroupBy" under the PCType field, and change to "Count" under your ID
field.

Run it.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
thats sound that is. Thanks guys. I don't mean to be picky but I'd really
what i'd really like to show is a field for each, ie a Field called Desktops
with the total and a field called Laptops with its total
can i do that?
 
Back
Top