Sorting data imported from Excel

O

odin

Can someone help me. I opened a spreadsheet of servers, users, and software
versions and need to generate a list that only tells how many users are on
each server. Is there a way to do this in Access.

Thanks.

Ed
 
O

odin

odin said:
Can someone help me. I opened a spreadsheet of servers, users, and
software versions and need to generate a list that only tells how many
users are on each server. Is there a way to do this in Access.

Thanks.

Ed
Click to expand...
Basically, I want to generate a list of how many server entries there are,
since that should tell me how me how many users are on each server.
 
D

Dirk Goldgar

odin said:
Can someone help me. I opened a spreadsheet of servers, users, and
software versions and need to generate a list that only tells how
many users are on each server. Is there a way to do this in Access.

Thanks.

Ed
Click to expand...

If I understand you right, it should be quite easy. But you don't give
enough information for a detailed response. Presumably you have linked
to this spreasheet so that it is seen as a table in Access -- or maybe
you imported it. Now, let's suppose the table is named "ServerData" and
it has fields like this:

Table: ServerData
Field: ServerName
Field: UserName
Field: SoftwareVersion

Do these fields have a hierarchical relationship, so that there can be
multiple UserNames per ServerName, and multiple SoftwareVersions per
UserName per ServerName? Or is there some other relationship among the
fields?

Your second post states that you really only need to know how many
records there are for each ServerName. If that's the case, then a query
with SQL like this will tell you:

SELECT ServerName, Count(*) As ServerCount
FROM ServerData
GROUP BY ServerName;

But I'm not sure whether that really does tell you what you want to
know -- it depends on the relationships among the fields.
 
Top