Multpile Criteria??

[Dawny]

I have three fields in an access table and I want to run a cross tab so that field one appears in the rows, field 2 appears in the rows and field three is the sum fields 1 and 2 in the relevant cells. Does anyone know how this is possible????

Also say if:
Field 1 has A B C D E J G through to Z and
Field 2 has A B C D E J G through to Z and
Field three has numbers ......
how do I only select the first 10 letter ie A to J

I hope this makes sense. Im very new to access and need all the help I can get.

Thanks inadvance
Dawn

 

[Dawny]

I meant to say field 2 appears in the columns

Sorry

 

[Norie]

Could you explain further?

What are you summing?

Does something like this work?

TRANSFORM Sum(Table1.Field3) AS SumOfField3
SELECT Table1.Field1, Sum(Table1.Field3) AS [Total Of Field3]
FROM Table1
WHERE (((Table1.Field1) Like "[A-J]"))
GROUP BY Table1.Field1
PIVOT Table1.Field2;

 

[Dawny]

Thanks but I have worked out how to do it (after a lot of playing)

It is a matter of using the 'or' function