Welcome to the Higher Administration blog of Mr McGowan.

It is the intention of this blog to be an additional and flexible resource allowing pupils to have more say in how, what and when they learn.

Higher Admin is challenging. But by using technology we can make it more accessible.

Do you wish a practice Nab for ITFM Outcome 3?

Thursday 24 January 2008

SumOf and CountOf

If you are asked to total (add) up something in Access, then in the appropriate query you select the icon that allows formulas (it looks the same as Autosum) and then you select SUM.

It is the same if you are asked to count the number of a certain thing (could be branches, number of sales made etc) then you use the query and then click on the Autosum and then COUNT.

No comments: