Aggregate Functions

1
Aggregate Functions

• by
• Barry Hynum
• MaxQual Consulting

2
Shameless Plug

• Access MDBs or ADPs
• Legacy Specialist
• SQL Server
• ASP.Net (Websites)
• Legacy ASP Classic COM
• Peachtree
• To Access or SQL Server

3
Access Help
4
Aggregate Functions
First Last Expressions
5
Queries
6
Design View
7
Design View (continued)
8
SQL View
9
Having
After aggregation
Product Sales for 1997_AvgQty
10
Forms Reports
Orders Subform
11
Control Source
12
Expression Builder
13
Advanced Issues

• Updating controls in Hdrs/Ftrs
• Referring to Controls in Sections
• Rpt Employee Sales by Country

14
3
2
1
5
4
15
Controls vs. Fields
1
2
3
To clarify, ALWAYS use a naming convention for
control names, i.e. txtGrandTotal. Aggregate
functions work on Fields, not Controls. (Hint
They are called SQL Aggregate Functions.)
4
5
16
Access Security

• Real World MS Access Database Protection
  Security by G. Robinson
• Access Security FAQ

17
(No Transcript)