Display only name checked in checkbox valuelist

[Brown932]

I am trying to create a few easier reports. This is a DB showing attendance. I have established a value list using checkboxes. This value list comtains approx. 40 plus names. What I would like to do is create a report the would show only those name checked on the value list to appear.(ex. Name1, Name2, Name3, Name4, Name5. Only Name 1 & 3 are checked - Only display 1 & 3 would be diplayed on report. Not whole list showing boxes checked aswell as boxes not checked) It needs to be flexable enough that 2 names could be diplayed or maybe as many as 25.

THANKS!!!!

[Fitch]

It sounds like you could just use your Names field, but on your report layout, format it as a standard field, and make it tall enough to accommodate your 25 names. Then use the Sliding/Printing options to slide up and reduce the size of the enclosing part.

Now, if you want to actually sort your report by name, that's a whole other can of worms.

[Brown932]

Thank works great but can I arrange the list in horizonally instead of vertical?

[EddyB]

Yes

Create a new field e.g c_DisplayNames

Make this field a calculation with the result being text

c_DisplayNames=

Substitute(Name, "

[Brown932]

What I meant to say is can I view the list in a multiple column list instead of one large column? Maybe limiting the number of names in each column. OR list them horizonal (6 or 8 names across) then jump down to another row and continue?

[EddyB]

Sorry I misunderstood what you were after.

Yes this should be possible, will be a bit more complicated though, I'll give it a try and repost.

Ed.

[EddyB]

OK, the only way I can find of doing this is to have x number of extra fields

x = the number of columns you require

New Field 1=

c_NameList1 (calc field)

c_NameList1 = LeftWords( Name , 10 )

New Field 2=

c_NameList2 (calc field)

c_NameList2 = MiddleWords( Name, 11 , 10 )

New Field 3=

c_NameList3 (calc field)

c_NameList3 = MiddleWords( Name, 21 , 10 )

New Field 4=

c_NameList4 (calc field)

c_NameList4 = MiddleWords( Name, 31 , 10 )

OK, what this will do if give you 4 fields

The first field will display the first column (first 10 selected names in your name field)

The second field will display the second column (next 10 selected names in your name field)

and so on...

There may be a simpler way, but I cannot think of one.

HTH

Ed.

[Brown932]

Just filling you in. It produced only 5 names in a column, but displayed the names in the order that they where entered or checked not alphabeticly. The value list is in alphabetic order. Any suggestions?

[-Queue-]

Don't use Name; use a calculation based on Name: ValueListItems( dbname, "valuelistname" )

[Himitsu]

Queue.. so do you have to put the dbname and valuelistname in manually? I tried it and couldn't get it to work... I want to do the same thing. Only show the check boxes that are checked..

[-Queue-]

I usually use Status(CurrentFileName) in place of 'dbname', and 'valuelistname' should be quoted and has to be manually entered.

[Himitsu]

EddyB said:

Yes

Create a new field e.g c_DisplayNames

Make this field a calculation with the result being text

c_DisplayNames=

Substitute(Name, "

[Brown932]

Anyone have any suggestions? I am looking to have the names appear in alphabetical order regardless of original entry.

[-Queue-]

Download Fenton's revision of my file here. This is a method for sorting the checkbox.

[Himitsu]

Queue... I got it and it is great... I will start to put it into action on my sheet.

[-Queue-]

Excellent! I'm glad I could be of help.