FInding records with multiple checked values using "or"

[JacJS]

I have a field with multiple values that are displayed as a checkbox set.

I would like to find all records that have the checked values of Z or Z2 or Z' or Z2'

I have very basic understanding of script writing only so created a button to perform a find with field "location" having criteria Z or Z2 or Z' or Z2' - this didn't work for some reason.

Ideally, i'd love to be able to count the total number of checkboxed values of either Z or Z2 or Z' or Z2'

Edited September 3, 2010 by Guest

[Raybaudi]

Hi

searching for Z or Z2 or Z' or Z2' is the same of:

Enter Find Mode

Find ==Z ( you'll have to use the Set Field script step )

Add New Request

Find ==Z2

Add New Request

Find ==Z'

Add New Request

Find ==Z2'

Perform Find

[JacJS]

Thanks Daniele,

Sorry but I'm not sure where to enter

Find==Z

Add New Request

Find==Z2

Add New Request

Find ==Z'

Add New Request

Find ==Z2'

As the scriptwriter for Set field "calculated result" does not recognised "Find".

Also is add new request the same as "new record/request"?

Any chance you know how to count the number of values that are checkboxed either Z, Z2, Z' or Z2'?

Thanks for your help

[Raybaudi]

Mine wasn't a real script, only some steps in English.

Enter Find Mode [ ]

Set Field [ YourTable::YourCheckboxField ; "==Z" ]

New Record/Request

Set Field [ YourTable::YourCheckboxField ; "==Z2" ]

...

...

Perform Find [ ]

[JacJS]

Hi Daniele,

It worked!!! But I had to use "=Z" instead of "==Z" before it would.

Any chance you know how to count the number of checkboxes that are selected within this found set?

Thanks,

Jaclyn :P

[Raybaudi]

Could you post your file ?

[Raybaudi]

It worked!!! But I had to use "=Z" instead of "==Z" before it would.

If you search for "=Z" you'll find records with Z but even records with Z' ( not to say that you'll find even records that contains multiple checked boxes with a Z and with other values checked ).

Searching for "==Z" gives a result ONLY if the field contains exactly a lonely Z

To count the occurrences of each value MAY BE that you could use a summary field but, could exist a record with that field containing multiple checked values ?

[comment]

I would like to find all records that have the checked values of Z or Z2 or Z' or Z2'

Do you have any OTHER values that begin with Z or contain words that begin with Z? If not, you could simply search for Z - this will find all records that contain a word that begins with Z.