Mathmatical Equation

[travismp]

Query... need to add totals:

3 Fields: [Name] [Type] [Test]

Table looks like this:

abc company | red | true
abc company | red | true
abc company | blue | false
mikes welding | red | true


Result:
abc company = 2 Red True
abc company = 1 blue true
mikes welding = 1 red true

is this possible within a query?

 

[WayneRyan]

Travis,

See Query1 in the attached DB.

Wayne

 

[travismp]

Thank you Wayne Ryan... I will see if I can figure it out and make it work from here. Thank you Sir.

 

[travismp]

Helped out a little, but not exactly what I needed. I reattached the database. I added a new table & query. I want the query to look like this...

ABC CONSTRUCTION DRUG PRE 1
ADVANCED AUTO PARTS DRUG PRE 1
ADVANCED AUTO PARTS ALCOHOL RAND 1
AMERICAN WELDING DRUG N-PA 1
AMERICAN WELDING DRUG N-RAND 1
AMERICAN WELDING DRUG PRE 2
AMERICAN WELDING DRUG RAND 4
ASSEST TRACKING DRUG PRE 2
ASSEST TRACKING ALCOHOL PRE 1
AZTEC WELDING DRUG PRE 2
AZTEC WELDING DRUG RAND 1
CONNER & CONNER ALCOHOL PRE 1
CONNER & CONNER ALCOHOL RAND 2
CONNER & CONNER DRUG PRE 3
CONNER & CONNER DRUG N-PA 1
CONNER & CONNER DRUG N-RAND 1


but it will not work out the way I want to... I tried your query, but it did not work... any ideas or help would be well liked. Thank you.

 

[flixx]

To travismp:
The only thing you needed to do in your query was to remove the iif statement from the new type field and just enter the field [Type]
Proper Syntax is New Type:Type.
which by the wau is qry_Main01 also created a qry_Main02 and did
a field rename in that field just to give a extra example.
I have re-attached your database below, hope this helps, Flixx.

 

[travismp]

Perfect

OK I see the difference. I would have never figured that out on my own so thank you so very much. I like Query02 better. I will use that one. This will save my account reps 4-5 hours a week of hand counting. Thank you again.