Re: Crosstab or Pivot Frustration


"Hansen" <helgardh@xxxxxxxxxxx> wrote in message
news:1193823540.746907.84700@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi

I have one table with the following design:
Fieldname Datatype
Region Text
Supply Number
Sales Number
Revision Number
Refused Number
SoldOut Number

I want to be able to report the data in the following format:
Total Region1 Region2 Region3 Region4
Supply
Sales
Revision
Refused
Soldout

I have been attempting this using crosstab queries and pivot tables to
no avail. I think I don't understand the concept. Can someone please
assis me?


Your table structure needs normalization.

Region InformationType Datavalue
-------- ---------------- ---------
Region1 Supply 1
Region1 Sales 2
Region1 Revision 3
Region1 Refused 4
Region1 SoldOut 5
Region2 Supply 6
....

With this table structure the Cross tab wizard could build a query to
produce your the required output.


.

Relevant Pages

  • Re: Excel 2007 auto format pivot table
    ... on the Design Tab you can select from ... Pivot Style Options ... heavy styles don't actually format the report at all. ...
    (microsoft.public.excel)
  • RE: Format report, fixed height for entries that must shrink?
    ... customers when they donate items to our organization. ... for several weeks to find a way to format this report so that each entry is ... format. ... single-column list of items in the design view cannot fit within that height. ...
    (microsoft.public.access.gettingstarted)
  • RE: How do I send a copy of a form to someone else
    ... Design a report that looks sort of like your form. ... format to a college in another office. ... paper work. ...
    (microsoft.public.access.gettingstarted)
  • Change Date Format
    ... Can I change date format on my ... On design page, I wrote ... This coding gives Day and Date, such as Friday, September ...
    (microsoft.public.access.modulesdaovba)