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

0 Response to "March 20: HUG Access SIG Meeting - Johnson County Community College"

Post a Comment

Group Tools

Random Prize Winner
Use this tool to generate random numbers for prize drawings.

Computer Humor Slideshow
Just for fun!




Follow this twitter list of the twitter accounts for the user groups. Ask for your group to be added to this list: twitter list
Subscribe to the Kansas City User Group Newspaper at Paper.li

Blog Archive

Followers