Problem with Multiple IF Condition

[guptapnr]

Hi
I've some data in A,B,C Columns in 10 rows,
A1 to A10 Names: Gupta, Raju, Rajesh, Ganesh, Raju, Raju, Rajes, Gupta...
B1 to B10 Models:Vehicle,Spares,Tools,Tools,Spares,Spares,Vehicles,Spares...
C1 to C10 Values: 15487,123654,125478, 122547,11457,9878,1254,1547....

I have query with the above data:
use if condtion with A & B columns sum with C column values
Like: Select the name in A column and select the model in B Column then the total value of the selected fields in A & B Columns and then result in D column selected Block i.e the C column of the selected fileds

How to use, plz clarify

 

[godsspeed]

Re: Problem with Multiple IF Condiction

im not sure im understanding exactly what you're going for:

are you wanting a user to select a name from Column A and a model from B and that given total to be displayed? or the total for all occurances of that combination?

can you give more details?

 

[Simon_MT]

Re: Problem with Multiple IF Condiction

Taking creating a Query with Totals

Group ColumnA
Group ColumnB
Sum Column C.

Simon

 

[guptapnr]

Re: Problem with Multiple IF Condiction

im not sure im understanding exactly what you're going for:

Are you wanting a user to select a name from column a and a model from b and that given total to be displayed? Or the total for all occurances of that combination?

Can you give more details?

i've give a sample data for my query
a b c
gupta vehicles 12547
raju spares 15487
rajesh tools 15478
ganesh tools 5647
gupta tools 1547
raju vehicles 45874
rajesh spares 1549
gupta spares 1240
ganesh spares 1365
gupta spares 1248
ganesh spares 3540
raju tools 1477

required result
gupta spares 2488

 

[vbaInet]

Re: Problem with Multiple IF Condiction

See the following link for a tutorial on how to sum in a query:

http://office.microsoft.com/en-us/access-help/sum-data-by-using-a-query-HA010096310.aspx

1. Group By a
2. Group By b
3. Sum on c