barnescs
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?
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), 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
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?
ASKER
This is the excel version of my table:
tbltotalspas.xlsx
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
<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
ASKER
OK, here it is
bid-counts---hours.accdb
bid-counts---hours.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is the rough form of what i am looking for. THANKS!!!!!!!
something like this
select count(jobid), sum(iif([award date] is null,0,1),sum([hours])
from tableName