• Status: Solved
• Priority: Medium
• Security: Public
• Views: 279

# Coiunting records & totaling hrs on Access table

I have a Access table that lists the jobs that we have placed a bid on in the last year and the number of hours that we bid.  I need to count the number of jobs, count the number of jobs that we have been awarded (award date is filled in) and the total number of hours that we have bid on all the jobs.  How can i do this?
0
barnescs
• 5
• 4
1 Solution

Commented:

something like this

select count(jobid), sum(iif([award date] is null,0,1),sum([hours])
from tableName
0

Commented:
sorry missing ")"

something like this

select count(jobid), sum(iif([award date] is null,0,1)),sum([hours])
from tableName
0

Commented:

something like this

select count(jobid) as TotalJob, sum(iif([award date] is null,0,1)) As TotalAwarded,sum([hours]) as TotalHours
from tableName
0

Author Commented:
instead of the select operation can i create a table so that i can generate a short report with just the totals on it?
0

Author Commented:
This is the excel version of my table:
tbltotalspas.xlsx
0

Commented:
why not upload a db with the table ...

<instead of the select operation can i create a table so that i can generate a short report with just the totals on it?>

when you made the select query working, just convert it into a make table query

select count([job#]) as TotalJobCount, sum(iif([date contract award] is null,0,1)) As TotalAwarded, sum([total hours bid]) as TotalHours
from tableName
0

Author Commented:
OK, here it is
bid-counts---hours.accdb
0

Commented:
run query1,

if that is what you want to see, you can change the select query into a make table query

bid-counts-hours.accdb
0

Author Commented:
That is the rough form of what i am looking for.  THANKS!!!!!!!
0

## Featured Post

• 5
• 4
Tackle projects and never again get stuck behind a technical roadblock.