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

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
Asked:
barnescs
  • 5
  • 4
1 Solution
 
Rey Obrero (Capricorn1)Commented:

something like this

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

something like this

select count(jobid), sum(iif([award date] is null,0,1)),sum([hours])
from tableName
0
 
Rey Obrero (Capricorn1)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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
barnescsAuthor 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
 
barnescsAuthor Commented:
This is the excel version of my table:
tbltotalspas.xlsx
0
 
Rey Obrero (Capricorn1)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
 
barnescsAuthor Commented:
OK, here it is
bid-counts---hours.accdb
0
 
Rey Obrero (Capricorn1)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
 
barnescsAuthor Commented:
That is the rough form of what i am looking for.  THANKS!!!!!!!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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