Figuring out who bought what when and how

Former Member
Former Member $organization

We had a problem with Transcend last month where our batch numbers matched for a short time.  During that week the first batch would post, the second would come back rejected as a dupe.  Now we want to re-submit those batches.  First though, we want to email our constituents to let them know that a small percentage of these sales did not go through and will be resubmitted and to call us with questions, etc. etc.

Web sales weren't affected.

Here's the question:

How can I pull a list of single ticket buyers for a specific date range where the moto ID is 102 or 101?

Parents
  • Hi, Nick:

     

    It may be that you need to put a single quote around 101: The definition of the field is as char(3), meaning that it’s looking for a string value there, not a number. Having said that, I get results, even with no single quotes.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    Florida Grand Opera

     

Reply
  • Hi, Nick:

     

    It may be that you need to put a single quote around 101: The definition of the field is as char(3), meaning that it’s looking for a string value there, not a number. Having said that, I get results, even with no single quotes.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager

    Florida Grand Opera

     

Children
No Data