Looking for a way to evaluate...

[SF]

Hi,

I have the following in a table:

Commune Billboard Safe File Cabinet
AAAA 0 1 2
BBBB 1 1 0

I want to know add a column to evaluate that Billboard not install, Safe not
procure etc...

Is there a way to do that?

 

[Guest]

Provide an example of what you want the output to look like.

 

[Joseph Meehan]

Hi,

I have the following in a table:

Commune Billboard Safe File Cabinet
AAAA 0 1 2
BBBB 1 1 0

I want to know add a column to evaluate that Billboard not install, Safe
not procure etc...

Is there a way to do that?

I am not sure what you want. Are you looking for a way to determine
which records have a zero for Billboard and a safe as zero or what?

If that is the case, you likely don't want to store that data in a new
field, but rather to recompute it on the fly anytime you need it. You could
use a select query. If you store the data, then you have the problem (or
advantage) of what happens when one changes. You would need to build in a
method of updating that new filed every time. Of course is you are
interested in only one point in time then you would want to store the
results.

 

[i_takeuti]

Hi,

I have the following in a table:

Commune Billboard Safe File Cabinet
AAAA 0 1 2
BBBB 1 1 0

I want to know add a column to evaluate that Billboard not install, Safe
not procure etc...

Is there a way to do that?