Hey Guys,

once again i enlist your help...

I have a field that is exactly the same on 3 records.I have another field on those records that say if the individual record is "opened" or "closed".

How can i set up a calculation so that it will first count how many of that first particular field are the same.... then add a number when all of them are "closed"...

any ideas?

A note to all beginners--please use your actual field names, tables and purpose. It's very hard to offer advice when you abstract out what you're trying to do.

In this post, "a field that is exactly the same on 3 records" means nothing. All fields are exactly the same on all records in the same table--it's the contents of the field that change. What does the OP mean? Who knows?

"To set up a calc so that it will first count how many of that first particular field are the same". First count, then what? I assume you mean content is the same. What content? A text value? A calc result? A type ID (one can hope)?

More specifics please.

NOTE: Repeating fields are a specific attribute of a field, in that the field is set to store multiple values in the same record. I believe the OP is misusing the term.

Edited July 21, 200817 yr by Guest
Repeating Fields Note

:iagree:

I would only add that; if it isn't easy to explain, then attach a copy of your file, or a mockup of it.

Lee

Edited July 21, 200817 yr by Guest

Sorry guys I'm a complete noob!!!

Thanks for replying here is the requested info~

ok...

I have three records

i have a drop-down menu in a layout stating if the record is opened or closed

i have a textbox called "PGNUMBER" otherwise known as Paragraph Number on Table "Page View"

here are some pictures...

each record is separate...

This picture shows you where everything is...

Picture 1

This picture shows you that nothing happens is one of the records "closed status" is changed

Picture 2

This Picture shows that the 2nd does the same

Picture 3

this shows that if all three are closed then 1 is added to the Closed requirement field which is a calculation

Picture 4

Which is the calculation of: "Closed requirement" ?

Isn't it a summary field: total of something ?

where something is a calc field:

Case( Closure Status = "Closed"; 1 )

i guess it doesn't have to be...

i just need it to do like i said above...

Isn't this exactly like you said above ?

... or do you want that the field "Closed requirements" contains 1 ONLY if all the 3 records have "Closure Status" set to closed ?

Eukanuba.zip

thanks for that file...

in response to your question i only want 1 instead of 3...

that is close to what i want to achieve but not quite...

I need the closed requirements to plus one only if the same paragraph number's are all closed

check the attached file...

the Db needs to see that

1.) duplicate paragraph numbers exist

2.) If all of the Opened/Closed fields are set to "close" for the duplicate paragraph numbers

then it should +1 to the closed requirement boxes or do a summary of how many unique paragraph numbers are closed...

Thanks So Much...

I feel we're getting close!!!

Keep up the Good Work

Eukanuba_Copy.zip

Ok, so give a try to this...

Eukanuba2.zip

Thanks SO much...

this is actually going to be used by NASA!!!

so i guess thanks from the United States of America!!!

thanks again

I imagine Søren's face reading that the future of United States relies on repeating fields... LOL ! :

:jester: :jester:

Ha Ha ... and I who thought Mark Leonard were a bit optimistic, might better revise the comprehension a.s.a.p.

http://www.johannhari.com/archive/article.php?id=598

--sd

I imagine Søren's face reading that the future of United States relies on repeating fields... LOL ! :

BTW: no repeating field is really involved in this topic. :

As bcooney said: the OP is misusing the term

Hi

Im new to the forum and did a search on my issue and it took me to this post. Hopefully its similar to the issue above.

I have a database that employees go on to register customers including their name and email. There is also a field called "times registered." What function would I use to count the number of times an email has been registered. So if [email protected] is in the database 5 times, the "times registered" field would have a value of 5. Thanks in advance.

Hi Phanman! Welcome to FM Forums!!

Create another table occurrence (duplicate) of your table and join them (called a self join).

Join: MainTable::eMailAddress = SelfJoin::eMailAddress.

Create a calculation (result is number) = Count ( SelfJoin::eMailAddress )

UPDATE... You could also use a summary field = count of eMailAddress. To view the proper results, place the self-join version of the calculation on your layout instead. The benefit of using summary instead of Sum() is that summary will change depending upon your found set.

Is this field a Repeating Field, or a related file?