Welcome to E-Goat :: The Totally Unofficial Royal Air Force Rumour Network
Join our free community to unlock a range of benefits like:
  • Post and participate in discussions.
  • Send and receive private messages with other members.
  • Respond to polls and surveys.
  • Upload and share content.
  • Gain access to exclusive features and tools.
Join 7.5K others today

MS Access guru needed

  • Following weeks of work, the E-GOAT team are delighted to present to you a new look to the forums with plenty of new features. Take a look around and see what you think!
Trending This Week
View More Trending
E

Entropy

Sergeant
609
18
8
I need some help on counting. I want to run a count on a query but the the count is based on a list of variables in another table.

The main table is 2 column list with PC name in col1 and the discovered software in col 2. Each app found is listed on a separate line so there are a number of lines with the same machine name and all apps found.

The counts that I want to do is count the machines with App1 ONLY installed, Machines with APP1 AND APP2 installed etc. The logic is AND, OR, NOT and ONLY.

Cheers
Ent
 
Hi Entropy, a suggestion from me would be to create a crosstab query from the Query Wizard, select the table you want that has the two columns you mentioned, click on next, then select the column with the PC ID, then select the column with the software, select next and next again, this view should have count selected, then select next again, then 'View the query and finish. You can then play about with several options, by using the wizard and experimenting, until it shows what you want.

This should be what you appear to be trying to do, and if exported from Access into Excel the query can be further manipulated and even produce charts from the data (I know you can produce charts in Access, but I find it easier in Excel).
 
You must log in or register to reply here.
Back
Top