Join us for the HUG Access SIG Meeting 6:30 pm, March 20, 2019, at JCCC, Regnier Center - 3rd Floor, RC 353.

Please note:  Rooms may change at the last minute if it is needed for classes.  Please see schedule boards or call 913-963-6693 if you have any trouble finding the group.

Presentation I:

Title:  Where vs. Having in Totals Queries

Presenter:  Susie Gilson

Description:  Are you HAVING trouble trying to figure out WHERE your totals query has gone wrong? Learn the          difference between “HAVING” and “WHERE” in Access SQL and which is processed first in a totals query. Crosstab queries will be touched on briefly.  

Bio:  Since the early 2000s, Susie has developed and used many database applications for her various roles with Girl Scouts. This includes several roles with GS Day Camp, where she developed and uses Access based applications for transportation logistics, cookout planning, unit scheduling, and registration for upwards of 400 registrants at a time. 

Q&A Session:  Bring your Access questions for the group to answer, explore or brainstorm ideas.

Presentation II:

Title:   Sub-TOTALS and  RUNNING Totals in an Access Queries?

Presenter: Jim Watkins, Jr.

Description:  Have you ever wanted Sub-TOTALs in an Access query? …or is Creating RUNNING totals in your Access queries slowing you down? Join us to discover some insights on these topics… we would love HAVING you WHERE we are meeting…

Bio:  Jim Watkins is a senior developer for Heritage Computer Consulting & Services, Inc. HCCS is a 24 year old Computer Consulting firm located in Overland Park, Kansas specializing in providing custom solutions to real world challenges for their clients.

Upcoming Meetings: 

03-20-19  – RC 353

04-17-19  – RC 353

05-15-19  – RC 353

06-19-19  – RC 353

07-17-19  – RC 353

08-21-19  – RC 353

09-18-19  – RC 353

10-16-19  – RC 353

11-20-19  – RC 353

12-18-19  – RC 353