Link to home
Start Free TrialLog in
Avatar of barnescs
barnescsFlag for United States of America

asked on

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?
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image


something like this

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

something like this

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

something like this

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

ASKER

instead of the select operation can i create a table so that i can generate a short report with just the totals on it?
This is the excel version of my table:
tbltotalspas.xlsx
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
OK, here it is
bid-counts---hours.accdb
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
That is the rough form of what i am looking for.  THANKS!!!!!!!