Re: Move records to columns???

From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
Date: Thu, 28 Jun 2007 19:26:39 -0700

On Thu, 28 Jun 2007 21:51:10 -0000, Starke <starke1120@xxxxxxxxxxx>
wrote:

Check out Crosstab query in the Help file.
When you create a new query, there is a wizard to help you.

-Tom.

I have a table that contains an SCC # and then locations, Qty, SKU.
As below

SCC Lcoation qty Sku
123 adffa 3 321a1 m
123 adfa 3 32111 l
123 adfa 3 32111 xl
123 adfffa 3 32111 s
321 adfffa 3 32111 m
321 addfa 3 32111 d
321 dfa 3 32111 s

What I need to do is go through the table and for all the same SCC
number, move the location to a column so that the scc contains one
record, but shows all locations, qty, sku on one record. Possible
create location 1, Location 2, Location 3, etc. I have 5000 records
to cycle through?

Any thoughts? Is this even possible?

Dave

Follow-Ups:
- Re: Move records to columns???
  - From: Starke

References:
- Move records to columns???
  - From: Starke

Prev by Date: Re: linked tables in 97 version not showing up in 2003
Next by Date: Re: Empty Bound Object Frames
Previous by thread: Move records to columns???
Next by thread: Re: Move records to columns???
Index(es):
- Date
- Thread

Relevant Pages

Re: Move records to columns???
... Are you really sure the data is as you describe, with qty being the ... same value for all occurrances of a particular SCC value? ... Check out Crosstab query in the Help file. ...
(comp.databases.ms-access)
Re: Move records to columns???
... Check out Crosstab query in the Help file. ... When you create a new query, there is a wizard to help you. ... could be missing something though.. ...
(comp.databases.ms-access)