Access Database: How do I get totals?

[Winchester]

Im doing a small timesheet database for ~6-7 people. I have them entering their time in forms online and then import the data into Access.

How would I go about adding up their total hours in different fields? Such as all the hours worked between such and such dates while working on project A.

 

[Thyme]

Use sum(hours). Look up aggregate sql functions.

 

[Winchester]

Anyone else?

 

[EagleKeeper]

You will have to set up a query to pull the records by the desired date.

The output of that query can then be summed as described by Thyme

 

[Winchester]

I will try that.

 

[SoundTheSurrender]

you run a query, add the table you want totals, then in that totals section you do a sum(insert column you want totals from) here.