How do I create a query for a list of account numbers, student numbers or last names?

+1 vote
32 views
asked Mar 4, 2015 in How To by Admin
reopened Dec 25, 2018 by yczehn
How do I create a query for a list of account numbers, student numbers or last names?

1 Answer

answered Dec 25, 2018 by yczehn
 
Best answer

Go to the General Info tab under the query screen.

Choose the field you want to query on (1). You can any or all of the following filters.

Text (2): Enter any text or a single account number. You can use the Like wildcards (%).

Multiple Values (3): You can enter on every line a single text to query. So if for example you want to query for 10 accounts you enter all of them one on each line.

Value Between (4): Let’s say you to query all accounts until letter L; you just enter an L in the second box. Later when you want to query from L you enter an L only in the first box. If you want between F and L, you fill in both boxes.

 

 

Let's Welcome our New Members

  • eerps of Cheder Chabad of Monsey - May 20, 2019

  • Tmendlowitz of Cheder Chabad of Monsey - May 16, 2019

  • Weisblum of Bnos Jerusalem Dchasidei Belz - May 13, 2019

  • gitta of Yaldeinu school - May 01, 2019

  • Briendy of Yeshivat Ohel Torah - May 01, 2019

  • total1542 of Business Halacha - Apr 29, 2019

  • moishey of hatzalah of KJ - Apr 09, 2019

  • sbender of Yeshiva Bais Binyomin - Mar 26, 2019

  • blschwartz of Yeshiva Bais Binyomin - Mar 18, 2019

...