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

+1 vote
87 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

  • astauber of JLS - Mar 27, 2024

  • yaakova of Bnos Menachem - Mar 26, 2024

  • GElefant of YGZM - Mar 21, 2024

  • bmiskin of Yeshiva Gedolah Zichron Moshe - Mar 20, 2024

  • cungar of Kollel Chatzos - Mar 18, 2024

  • sstein of Masores - Mar 18, 2024

  • RochelPultman of Prospect Park Yeshiva - Mar 11, 2024

  • rlefkowits of talmud torah ohel yochanan - Mar 11, 2024

  • Barber739 of Bnos Menachem - Mar 10, 2024

  • Chani Schwarz of Yeshiva K'tana of Waterbury - Mar 07, 2024

...