Re: Reorganize MS Access Table

I have tried the crosstab; it doesn't give me exactly what I want - it
lists all the products for column headings (about 760) in this case. So
I will have more than 780 column headings. I need a way to update a new
table so that it looks like the 2nd table shown above: the column
headings are already there, so the query grabs the the products for a
delivery and puts them under a column heading (doesn't matter under
which field as far as it is associatedwith the appropriate delivery).
Thanks for your help guys.

.

Relevant Pages

  • Re: Update a 2nd Table
    ... > So that there is only one line of record for each delivery. ... > I have tried crosstab query; it doesn't give me exactly what I want - ... > it lists all the products for column headings in this case. ... > delivery and puts them under a column heading (doesn't matter under ...
    (comp.databases.ms-access)
  • Re: Reorganize MS Access Table
    ... > I have tried the crosstab; it doesn't give me exactly what I ... > want - it lists all the products for column headings (about ... > appropriate delivery). ...
    (comp.databases.ms-access)
  • Update a 2nd Table
    ... So that there is only one line of record for each delivery. ... I have tried crosstab query; it doesn't give me exactly what I want - ... So I will have more than 780 column headings. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Dynamic Reporting based on Parameterized Crosstab Query
    ... Since the column headings are all dates at a regular interval, ... charge date charged hours are associated with. ... on the first 3 rowwise fields of the crosstab query. ...
    (microsoft.public.access.reports)
  • RE: Dynamic column in report using crosstab query
    ... What is the SQL of your crosstab that generates the error. ... H. Frank Situmorang ... "Duane Hookom" wrote: ... You need to use a reference year to calculate your column headings. ...
    (microsoft.public.access.reports)