Query Direction??

[Guest]

Alright i need some direction in how i can get a query or multiple quries to
get the information i need.

I have a table with the following columns with explanation for what they
contain
EstNo - specific estimate number
Awarded GC - Awarded General Contractor
Other GC1 - General Contractor that bidded #1
Other GC2 - General Contractor that bidded #2
Other GC3 - General Contractor that bidded #3
Status - If the project has been won, lossed, or is still pending
Awarded Electrical - Actual Electrical Awarded
Other Electrical 1 - Electrical Contractor that bidded #1
Other Electrical 2 - Electrical Contractor that bidded #2
Other Electrical 3 - Electrical Contractor that bidded #3
Project Type - a broad project scope, commecial, medical, educational, etc.
Subtype - narrows the project type down a little bit school, office,
church, etc.

With the these columns i would like to get that from information is the
counts for all the general contractors, who won the projects, what projects
and subtypes we are bidding and winning, and so forth.

So if someone can tell me what i need to do i woul geatly appreciate it.

I have got one query figured out, which is how many wins, losses, and
pending for the awarded gc. If i could get some direction into how to include
the other GC columns with win, loss, and pending counts.

Thanks in advance for all your help

Andy

 

[[MVP] S.Clark]

For starters, you have a non-normalized table. So, EVERYTHING you try to
do with it is going to be a challenge.

You can work around it, but it will payoff in the long run to restructure
the table.

 

[Guest]

How would i normalize the table???

For starters, you have a non-normalized table. So, EVERYTHING you try to
do with it is going to be a challenge.

You can work around it, but it will payoff in the long run to restructure
the table.