Reports

[liam_conor]

For give me for my ignorance...I am new to creating reports in access. ray:

I have a query that returns the following information. I want to create a report the returns the sum of VALUE for each Location using an ID number (MSPC) as the criteria.

Here is an example of what my raw data output looks like...

Loc Loc_ID MSPC SPC VALUE DATE
Ba 34 100 987 14 1/1/2002
Ba 34 100 987 4 1/1/2002
Ba 34 200 355 56 1/1/2002
Da 34 200 355 11 1/1/2002
Da 34 100 987 3 1/1/2002
Da 34 500 987 9 1/1/2002
Fl 34 100 987 6 1/1/2002
Fl 34 300 577 3 1/1/2002
Ba 34 200 355 5 1/1/2002
Ba 34 100 987 4 1/1/2002
Er 34 400 238 33 1/1/2002
Er 34 400 238 45 1/1/2002
Er 34 400 238 2 1/1/2002
Er 34 100 987 345 1/1/2002
Er 34 700 347 6 1/1/2002
Tp 34 100 987 7 1/1/2002
Mn 34 600 123 6 1/1/2002
Mn 34 600 123 1 1/1/2002
Mn 34 100 987 45 1/1/2002

Here is an example of what I want the report to look like...

MSPC Ba Da Fl Er Tp Mn
100 22 3 6 345 7 45
200 61 11 0 0 0 0
300 0 0 3 0 0 0
400 0 0 0 80 0 0
500 0 0 0 0 0 0
600 0 0 0 0 0 7
700 0 0 0 6 0 0

How would I create something like this? Any Examples?

 

[bat17]

You will need to use a crosstab query to get the data into the right order for your report.
If you run the Crosstab Query Wizard you should be able to see what you want to do.
On the first page select your existing query, click next.
Select the MSPC field and click next.
Under fields select Value and under functions select Sum click next.
Give it a name and finish.

HTH

Peter