Calculating a column

[cknutzen]

I'm new to Access and think my Excel experience is making things difficult for me.
I want to enter in data as shown and then figure out the percent completed (done/present). I will need to be able to sort these percentages by person, job number and dates. For example what is Matt Elder's percent complete for June 2012 at job 150127?



Any help would be appreciated!

[June7]

Tables hold raw data. Manipulate data with queries. Build a query with calculated fields. This is basic Access functionality and Access Help has guidelines. However, percent calculation usually involves aggregate calcs. This is best done on report using Grouping & Sorting features with aggregate calcs in group and report header/footer sections.

Google: access report percentage of total

http://office.microsoft.com/en-us/ac...005187381.aspx