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 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
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
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
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 :-(
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.
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
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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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.
...
|
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...
|
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...
|
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...
|
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...
|
by: Sam |
last post by:
Hi,
How can I move a row in my dataview to the first position ?
Thx
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
| |