This folder contains 11 articles

How-To's and Troubleshooting

Date Formats in Query
You can Query by Date and Time LIST LOG BY DTS IF OB : STU AND DTS > "8/23/2023 8:08 AM" AND DTS < "8/23/2023 12:58:53 PM"   ...

Fri, Jul 5, 2024 at 10:51 AM

Ethnicity/Race in Query
In the past, the extended field RACE was not working. This is a workaround for the field to create one column that shows the Ethnicity/Race For a Query ...

Sat, Aug 10, 2024 at 6:08 PM

How to Print a List of Teachers and the Sections They are Teaching in a Flex School
How to print a list of Teachers and the Sections they are teaching in a Flex Scheduling setting:  This information can be listed with the following quer...

Mon, Jul 29, 2024 at 12:58 PM

How to Query Current Year Students in the Homeless Program (191)
To obtain query results for Homeless Program (191) records for students with an Eligibility Start Date within the current school year and no Eligibility End...

Wed, Oct 16, 2024 at 10:09 PM

Open Query Results in Google Worksheet
If you do not have Excel on your computer, you can still use the Excel Button in Aeries Query. Step 1: Select the Excel Button on Aeries Query: St...

Thu, Aug 15, 2024 at 3:23 PM

Query - How to Save Queries Created by Another User
When a user discovers a saved Query created by another user and wishes to save it under their own username for future use, this can be done by saving the Qu...

Sat, Aug 10, 2024 at 6:16 PM

Query - Table not Working With STU
Question: Why does a Query not work with the STU table? Answer: When creating a Query, sometimes a connecting table needs to be included.  Example: ...

Sat, Aug 10, 2024 at 6:11 PM

Query to Mass Populate Counselor Field (STU.CU) for Secondary Schools
How to use a CHANGE Query to mass populate the Counselor field (STU.CU) for a Secondary school, not using Staff ID Based Counselor Tracking.  If the co...

Tue, Aug 6, 2024 at 4:42 PM

Query to Mass Populate the Counselor field (STU.CNS) - Secondary Schools Using Staff ID Based Counselor Tracking
How to use a Change Query to mass populate the Counselor field (STU.CNS) for a Secondary school using Staff ID Based Counselor Tracking.  If the counse...

Thu, Aug 15, 2024 at 3:08 PM

SMAA School-Base Medi-Cal Administrative Activities
Determining Eligibility for School-Base Medi-Cal Administrative Activities (SMAA) https://www.dhcs.ca.gov/provgovpart/Pages/SMAA.aspx The file must have...

Thu, Aug 15, 2024 at 3:23 PM