Jump to content

Get Count of particular field contents


This topic is 5705 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have two fields: Networks and Servers. There can be many Servers which all belong to the same Network. But no Servers belong to more than one Network. Each record I have looks something like this:

Network  Server

A             a

A             b

B             a

B             b

B             c

C             a

So what I'm trying to find is -- using a Calc field if possible so the data can remain constant, i.e., not dependent on summary layouts -- how many Servers does each Network have? (In this case, A=2, B=3, C=1).

Link to comment
Share on other sites

You should have a related structure:

Two Tables:

Network

NetworkID_PK

cn_numberServers

Where cn_numberServers is a calculation field result number = Count(Servers::NetworkID_FK)

Servers

NetworkID_FK

ServerID_PK

Link to comment
Share on other sites

This topic is 5705 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.