Query Deposit based on percentage

0 votes
606 views
asked May 18, 2018 in Support Questions by BYBZ
Hi

We would like to have a query for parents who did not submit x% of deposit required. i.e. if we require a 50% deposit for day camp, the query should be for 50% f the July charge. Being that each parent is charged based on amount of children or other discounts, using an absolute dollar figure won’t accomplish what we’re looking for.

Thanks,

1 Answer

answered May 22, 2018 by Admin
selected May 22, 2018 by Admin
 
Best answer

Added. Just enter a percent sign by the query.

 

commented May 22, 2018 by BYBZ
Thanks Much.

The example above uses the Amount Field when it should really use the balance due field.

is there anyway to include the Future Credit cards in this tab as well?
commented May 22, 2018 by Admin
No difference what you choose, Amount or Balance Due. Its calculating the balance due against the amount.

No, Future CC Cannot be part of this.

Let's Welcome our New Members

  • Wck of Willowbrook Community Kollel - Feb 17, 2026

  • Mr Y greenwald of Tov vchesed Rachmistrivka - Feb 10, 2026

  • Kritzler YS of pupa - Feb 09, 2026

  • Shimon of Vehareinu Skver - Feb 09, 2026

  • Gutwein of Lakefront - Feb 08, 2026

  • dgross of yeshiva orchos chaim - Feb 03, 2026

  • SrulyF of JLS - Feb 02, 2026

  • Flor of Little Munchkins Playgroup 56 Inc - Jan 29, 2026

...