Changing 1/0 response to text?

[Sara H]

Hey everyone, I have a problem I'm hoping you can help with. I am trying to put a flag on my main layout that identifies if a constituent has purchased one (vs. multiple) tickets to our season of events.

I've tried to use the "is empty" logic function but so far can't get it to work. For some reason it keeps "judging" fields names similar to the one I really want to use (i.e., "Adult Single Ticket Sold" v. "Adult Applause Ticket Sold").If the field "Adult Single Ticket Sold" is empty but the "Adult Applause Ticket Sold" is not, it returns a false response (i.e., that there was an Adult Single Ticket sold).

Anyone know what I'm doing wrong? I've checked the fields to make sure I do, in fact, have separate ones.

Thanks.

Sara

[bcooney]

Do you mean it's seeing field values as the same (not the field names)?

Anyway, what is the field, "Adult Single Ticket Sold"? Is it a number field, and set to a checkbox with the value list of 1? If so, then you can sum this field to see how many checkboxes of this field are checked.

Not knowing more about the fields and the table structure, it's hard to see where you are going wrong. Try to have flag fields equal 1 or nothing, not a text string.

[Sara H]

Hey there,

The fields each track the number of tickets of a certain type purchased by an individual. There are a bunch of different types - Adult Trio, Adult Applause, Discounted Adult Trio, Discounted Adult Applause, Student Trio, Student Applause... and then there are individual ticket sales for both Adults and Students. Someone could buy one or two or six of any of the ticket types.

I don't need to total anything... I just need to identify and flag any records that involve the sale of individual tickets.

This is the calculation I wrote:

Number of Adult Tickets>0 or

Number of Student Tickets>0

The result is set to return a number (although ideally I'd like to just have a check box if the result is True).

The problem is, the calculation is returning a value of True for anyone who bought any type of ticket. Those sales are identified in different fields than the two in the calculation but are still somehow being calculated (it seems). Obviously I'm doing something wrong.

Sara

[Sara H]

I'm not sure what I did but it's sort of working now. It's returning a value of 0 for those who bought single tickets and leaving the others blank.

Thanks for the help!

Sara

[bcooney]

I would suggest, if you don't have this already, a table of ticket types, each with a unique id.

Then you can easily analyze ticket sales by either finding for type (id) or building relationships using typeIDs.