Access Query, count records and total quantity field
Posted on 2011-09-21
i asked this question Monday:
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?
and got this response: SELECT Count(tbltotalspas.[CPP #]) AS [CountOfCPP #], Sum(IIf([DATE CONTRACT AWARD] Is Null,0,1)) AS NoOfContractAwarded, Sum(tbltotalspas.[TOTAL HOURS BID]) AS [SumOfTOTAL HOURS BID], Sum(tbltotalspas.[TOTAL ACTUALS]) AS [SumOfTOTAL ACTUALS]
but when i click on the "run" button i get this error message: Data type mismatch in criteria expression.
Can anyone tell me what to change? i have tried a couple of things but so far i haven't been able to get it to work.