Make duplicate Records for Wire Labels

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!


Thanks for the input,

Phil



"KARL DEWEY" wrote:

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

But it loaded the query with 8 copies in every instance; not the 4, 6, or 8
from each record of the Wire_Label_QTY field.

Did you get it to work?
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!


Thanks for the input,

Phil



"KARL DEWEY" wrote:

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

Close...

Here was my post back to you... Can you help me streamline it so it produces
the appropriate number?

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!

Thanks,

Phil Elmers

"KARL DEWEY" wrote:

But it loaded the query with 8 copies in every instance; not the 4, 6, or 8
from each record of the Wire_Label_QTY field.

Did you get it to work?
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!


Thanks for the input,

Phil



"KARL DEWEY" wrote:

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

Check and see if [Wire_Label_QTY] and [CountNUM] are number fields.

--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Close...

Here was my post back to you... Can you help me streamline it so it produces
the appropriate number?

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!

Thanks,

Phil Elmers

"KARL DEWEY" wrote:

But it loaded the query with 8 copies in every instance; not the 4, 6, or 8
from each record of the Wire_Label_QTY field.

Did you get it to work?
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!


Thanks for the input,

Phil



"KARL DEWEY" wrote:

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?

KARL YOUR A GENIUS!!! IT WORKED!

Here's what I Learned-- to share with other Novices---

You sent me this-
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]))

1. I didn't initially send you the actual Table and Field names, so the
above was not quite accurate. I converted it to this-
SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]))

2. The CountNumber Table was in text, not numbers- I corrected it but
still printed 8 of each because I didn't use the WHERE line

3. The "WHERE" line- I didn't know what to do with it; I pasted it in the
criteria line and got an error. Then I tried it in the OR line and IT
WORKED!!!

Thanks, Karl

Phil Elmers
2nd Gen Wireless LAN Project Manager









"KARL DEWEY" wrote:

Check and see if [Wire_Label_QTY] and [CountNUM] are number fields.

--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Close...

Here was my post back to you... Can you help me streamline it so it produces
the appropriate number?

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!

Thanks,

Phil Elmers

"KARL DEWEY" wrote:

But it loaded the query with 8 copies in every instance; not the 4, 6, or 8
from each record of the Wire_Label_QTY field.

Did you get it to work?
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

Karl,

Here is my naming convention pasted into your format:

SELECT Label_Scheme.Label_ID, Label_Scheme.Wire_Label_QTY,
CountNumber.CountNUM
FROM CountNumber, Label_Scheme
WHERE (((CountNumber.CountNUM)=[Wire_Label_QTY]));

In CountNUM I made 8 records; 1,2,3,4,5,6,7,8

So, I did my Query in design view...
I made the three columns from the appropriate tables, But it loaded the
query with 8 copies in every instance; not the 4, 6, or 8 from each record
of the Wire_Label_QTY field. What I didn't know how to do-- load your
"WHERE" formula in the query. Your other concept of setting it to "0" is
intriguing, but I'm learning to walk!


Thanks for the input,

Phil



"KARL DEWEY" wrote:

Create a table named CountNumber with field named CountNUM with numbers from
1 to your maximum.

Use this query ---
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY]));

I use the CountNumber table a lot for date spreads so I have 0 (zero) in the
table. If you do then use the following query --
SELECT Labels.Label, Labels.QTY, CountNumber.CountNUM
FROM CountNumber, Labels
WHERE (((CountNumber.CountNUM)=[QTY] And (CountNumber.CountNUM)0))
ORDER BY Labels.Label;
--
KARL DEWEY
Build a little - Test a little


"2GWLAN" wrote:

I need to make wire labels in 4, 6, or 8 copies of each in Access 2007. I
have imported each designation from excel into a table and sorted it. As an
example the record says "1.1.1 (105)". I have also created a Quantity field
with the number of labels reqied for each wire run. I would like to take
this record, multiply it by the Quantity Column, create the required number
of duplicate records, and put these expanded label records into a new table.
After that, I will send it to the label wizard for mass printing. I created
a custom label format for these unique PanDuit Brand wire labels. How do I
format a Query to do this, or is there a better way?