Should I use a case function?

September 8, 200520 yr

I am trying to build a report that tells me how individuals have paid (ie, check, charge, po, etc.) Each of these is set up as a vlue list and set up with radio boxes for easy data entry. I need to build a report that lists each customer by name and then tells me which way they paid -- but I need each value to be it's own field. See below for a rough example of how the report would look

Name Check Charge PO

John Doe X

Jane Doe X

Josh Doe X

I know (or think) that I will need to set up a container field for each "check", "charge" and "po." In each of those container fields would I do a If (Is Empty(Payment Method), "X", "empty")? But how do I specify each option (from the value list) in that field -- check or charge or po???

Can I even do this?

thanks in advance

September 8, 200520 yr

You haven't to make a new (container ) field !

neither you need a calc.

Simply make a new layout (list view) with two fields:

1) name

2) payment Method

with the last formatted as check box

September 8, 200520 yr

Author

I'm trying to pull the data from the value list (radio buttons) and report them as seperate fields. Isn't this just a way to set the value list up for data entry? I have that -- I now need to pull that data into a report (but without the radio buttons) that tells me in column format if they paid by check (yes/no), charge (yes/no), or po (yes/no)

???

September 8, 200520 yr

The values that actually go into a field from the use of radio buttons or a checklist are the text values on the radio buttons or checklists. The difference is that only one value winds up in the field from a set of radio buttons, versus multiple values from a checklist separated by a CR. So yes, you'll wind up with the values you think you need.

Steve