473,327 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Move records to columns???

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

Jun 28 '07 #1
7 1984
On Thu, 28 Jun 2007 21:51:10 -0000, Starke <st********@hotmail.com>
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
Jun 29 '07 #2
On Jun 28, 10:26 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Thu, 28 Jun 2007 21:51:10 -0000, Starke <starke1...@hotmail.com>
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
I tried crosstab query before posting but it appeared that it wants to
summarize the records and not display them as the row as a column. I
don't need the sum, or count I just need the row in a column(s). I
could be missing something though..

Thanks,

Dave

Jun 29 '07 #3
On Thu, 28 Jun 2007 20:14:33 -0700, Starke <st********@hotmail.com>
wrote:

Indeed it wants to run an aggregate function on the data, because
that's what most people would want. If you are not among them, you're
on your own writing the code yourself.

Are you really sure the data is as you describe, with qty being the
same value for all occurrances of a particular SCC value? If not, how
are you going to decide which qty to use?
That's where crosstab queries would use Sum(qty)

-Tom.

>On Jun 28, 10:26 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
>On Thu, 28 Jun 2007 21:51:10 -0000, Starke <starke1...@hotmail.com>
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

I tried crosstab query before posting but it appeared that it wants to
summarize the records and not display them as the row as a column. I
don't need the sum, or count I just need the row in a column(s). I
could be missing something though..

Thanks,

Dave
Jun 29 '07 #4
On Jun 28, 11:51 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Thu, 28 Jun 2007 20:14:33 -0700, Starke <starke1...@hotmail.com>
wrote:

Indeed it wants to run an aggregate function on the data, because
that's what most people would want. If you are not among them, you're
on your own writing the code yourself.

Are you really sure the data is as you describe, with qty being the
same value for all occurrances of a particular SCC value? If not, how
are you going to decide which qty to use?
That's where crosstab queries would use Sum(qty)

-Tom.
On Jun 28, 10:26 pm, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Thu, 28 Jun 2007 21:51:10 -0000, Starke <starke1...@hotmail.com>
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
I tried crosstab query before posting but it appeared that it wants to
summarize the records and not display them as the row as a column. I
don't need the sum, or count I just need the row in a column(s). I
could be missing something though..
Thanks,
Dave
Here is what I need to do, and maybe Im going about it incorrectly.

The table is as stated above. I am trying to print an SCC content
label in Bartender. For all the records that have the same Container
ID, PO, Store # etc it will need to be printed on the header part of
the label, then for all the same header ifno will have SKU, Customer
SKU, QTY etc as line detail that will print in the details section of
the label. The only way I know how to do this is to have one line per
record and map each column to text or barcode in Bartender.

There is probably a better way of doing this in bartender, but I can't
seem to find a group for bartender. So I thought if I could get a
query to populate the data in one record then I can take it from
there.

Confusing huh.. I think im stuck :-(
Jul 2 '07 #5
On Jul 2, 9:33 am, Starke <starke1...@hotmail.comwrote:
Confusing huh.. I think im stuck :-(
Instead of trying to explain it, draw it out like you did the original
table - how you want it to look.
Jul 2 '07 #6
On Jul 2, 3:36 pm, "christianlo...@yahoo.com"
<christianlo...@yahoo.comwrote:
On Jul 2, 9:33 am, Starke <starke1...@hotmail.comwrote:
Confusing huh.. I think im stuck :-(

Instead of trying to explain it, draw it out like you did the original
table - how you want it to look.
SCC Lcoation qty Sku Loc2
qty2 Sku2 Loc3 qty3 Sku3
123 adffa 3 321a1 m
afdfa 2 212512 adfa 5 542125

So if scc 123 has 7 records, there would be columns upto Loc7 and if
the next scc only had three records then columns upt o loc 3 would be
filled in. This is a BS way of doing this, but I call Seagull
Bartender Tech support and they stated bartender can not run through
records and print a header and then details that it prints only one
record at a time and I need all the data I want on one record to be in
one record.

Thanks,

Dave


Jul 5 '07 #7
On Jul 5, 2:59 pm, Starke <starke1...@hotmail.comwrote:
So if scc 123 has 7 records, there would be columns upto Loc7 and if
the next scc only had three records then columns upt o loc 3 would be
filled in. This is a BS way of doing this, but I call Seagull
Bartender Tech support and they stated bartender can not run through
records and print a header and then details that it prints only one
record at a time and I need all the data I want on one record to be in
one record.
Yeah, that's bogus. You can cycle through the records and print it
like that using the Recordset object. Having it show up in a table
though... I don't know.

-------------------------------------------------------------------------------------------
The table is as stated above. I am trying to print an SCC content
label in Bartender.
-------------------------------------------------------------------------------------------
I really don't understand what a 'content label' is. Are you referring
to the columns in a table?

Your first statement:
-------------------------------------------------------------------------------------------
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?
-------------------------------------------------------------------------------------------
"What I need to do is go through the table and for all the same SCC
number"

Is this the many part of a one to many relationship?
Jul 6 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: tom | last post by:
I am new to SQL administration. >From a list of IDs that are the primary key in one table (i.e. Customer Table), I want to make changes in tables that use those IDs as a foreign key. ...
6
by: Matt K. | last post by:
Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form...
2
by: PeteCresswell | last post by:
This is pursuant to another thread I tried to start, but can't find on my server. I've got to store rolling rates of return for investment funds - calendar year, quarterly, and monthly To cut...
5
by: Tim | last post by:
Hi, I am trying to move a datacolumn in a datatable. What I have tried so far is to create a new datacolumn set it equal to the one I want to remove and then remove it, add another column and...
1
by: jwogick | last post by:
I'm hoping someone can help me! I just have a simple form with a datagrid displaying child records from a dataset that contains two related tables Parent table>Clients Child table>cases. using the...
1
by: Sam | last post by:
Hi, How can I move a row in my dataview to the first position ? Thx
14
by: Peter | last post by:
Is there a fast way to move data from DataTable into double array, or do I have to spin through every record and column? I have five tables and I need to merge these tables column wise, each table...
1
by: Greg | last post by:
I'm using a DataGridView object bound to an xml datasource. I have added 2 unbound columns which are populated based on the calculations of data from other columns. When the data in the other...
8
by: jmarcrum | last post by:
I have a table with about 100 records. The user has the ability to click a button on the main form that will open up a "move to the next year" form. A query displays all 100 records on the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.