Should I use a case function?

[detailscreative]

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

[Raybaudi]

Hi

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

[detailscreative]

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)

???

[SteveB]

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

[Raybaudi]

see the attachment..

Payment.zip

[detailscreative]

Can you save this back to 6 -- I don't have 7 yet!!!!

[Raybaudi]

Oh, You own 6 !

Sure...

PaymentFM6.zip