Adding values based on status?

[mechInferno]

Hey I'm new to Access and been racking my brain. I am trying to pick a certain status then add up the values that go with it.
ex.

Status CustName Value
Job ---- $15,000
Dead ---- $30,000
Job ---- $150,000
Job ---- $10,000

Total Value based on Job status = 175,000

This should leave out the status' that are not "job"

There are a lot more rows in the DB, but this is an example. Anyone know how to work this?

 

[PHV]

In the SQL view pane of the query window:
SELECT Status, Sum(Value) As Total
FROM yourTable
WHERE Staus = 'Job'
GROUP BY Status

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mechInferno]

Sorry I should have mentioned that I was trying to get the info while making a report. So far I have everything, but I need to report on how many bids have the job status and what the total value is of all the jobs per person.