Display Text Values as Labels on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three fields in a table: Points and Player and Region. The Points
field contains various numbers of points (456 or 1032 or 103 etc). The
Player field contains players names (Bob or Joe or Judy etc). The Region
contains region names (East Coast or West Coast or MidWest etc). I would like
to create a report that lists each player across, each Region down, and then
lists the total number of points for each player based on region.

I tried creating a query summing the points for each possible combination of
players and regions and then combining all the queries into one, but the
query is too complex.

Any ideas?
 
NeedHelp said:
I have three fields in a table: Points and Player and Region. The Points
field contains various numbers of points (456 or 1032 or 103 etc). The
Player field contains players names (Bob or Joe or Judy etc). The Region
contains region names (East Coast or West Coast or MidWest etc). I would like
to create a report that lists each player across, each Region down, and then
lists the total number of points for each player based on region.

I tried creating a query summing the points for each possible combination of
players and regions and then combining all the queries into one, but the
query is too complex.
Click to expand...


This sounds like a classic Crosstab query. Try creating a
new query and use the query wizard to help you create it.
 
Thank you. I've tried creating a crosstabs query and then basing the report
on the crosstabs query but it still doesn't allow me to treat the sumpoint
field as its own field (I want to be able to move the data around so that I
can design the report to look the way I want it to look:

Joe Judy
West Coast 8,094 645
East Coast 543 2,145

I can get my crosstabs query to look that way, but not my report - at least
not in a way that gives me design flexibility.

I'd appreciate any further help you can give me on this.
 
I do not understand. What do you mean by "design
flexibility"?

What version of Access are you using?

Before we go any further, you will have to explain your
table(s?), their significant fields and how you want the
report to look.

At this point, about the only other thing I can guess is
that maybe you're looking for a Totals type query:

SELECT player, region, Sum(amount) As TotalAmount
FROM sometable
GROUP BY player, region

but getting that to list the names across the page will get
into all kinds of complications.
 
Back
Top