Your Cart | Sign In | Register
Query: Closed Status
Moderator(s): Cireena Katto, Your Membership, Chelsea VanSolkema, YourMembership
Thread Score:
Page 1 of 1
Thread Actions

11/3/2017 at 3:54:42 PM GMT
S. Shark, Colorado Mining Association
Posts: 1
Query: Closed Status
I'm trying to run a query to show me all members with an open status on their invoice, but the criteria wants me to include a number value, not the word "closed." I've attached a screen shot. How do I get this to run those with a closed status?

 Attached Files: 
closed status screen shot.docx (269.5 KB)
11/3/2017 at 4:58:46 PM GMT
S. Graham
Posts: 8
Stephanie, 0 = an open invoice, so if you enter "0" that would be open, "1" is processed, "2" = shipped and "-1" =cancelled. I hope this helps!


11/3/2017 at 5:26:42 PM GMT
S. Shark, Colorado Mining Association
Posts: 1
Sorry, I meant to say I was looking for those with a closed status (not open). Is "1" processed the same as closed? I'm not getting anything when I use a 1 in the query...


11/6/2017 at 3:45:07 PM GMT
S. Graham
Posts: 8
Stephanie, are you looking at dues, or store or donations? You might be better off, pulling this report from the ecommerce tab?


11/7/2017 at 9:29:32 PM GMT
T. Maysonet, Florida International Bankers Association (FIBA)
Posts: 5
Hi Stephanie, we do these type of reports very often but we use the ecommerce tab. 


Explore all of our solutions: YM Membership | YM Learning | YM Careers