field total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to add a total at the end of my query totaling up a field...how
would i go about doing this? The field in question has number of vacation
days being taken it only has 1 day or .5 days so i need it to actually count
the numbers and get a total.
thanks
 
Dean said:
I would like to add a total at the end of my query totaling up a field...how
would i go about doing this? The field in question has number of vacation
days being taken it only has 1 day or .5 days so i need it to actually count
the numbers and get a total.
thanks
Click to expand...

In JET SQL you can't put a Total at the end of a query. Try putting the
query in a report & put a Total Text Box in the report's footer.

See the Access Help article "Calculate a total or other aggregate
values" for more info.
 
that is where i wanted it in the first place, i thought i had to do it in the
query first

thanks
 
Back
Top