Totals in Query's

D

danijela.simunovic

Hi!
Is there a way to make a row in a query, I would like to be the first
or the last row and that it contains totals of all the data in the
query(of that column,or all columns,or have some formulas)? And can i
freeze the first row where would those totals be?
Thanks,

Danijela
 
R

rico

Use a form to display the information from the query, you can create the
total fields in the header or the footer of form.

HTH

Rico
 
Top