Make duplicate Records for Wire Labels

2

2GWLAN

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?
 
K

KARL DEWEY

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;
 
2

2GWLAN

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 said:
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 said:
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?
Click to expand...
Click to expand...
 
K

KARL DEWEY

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 said:
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 said:
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 said:
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?
Click to expand...
Click to expand...
Click to expand...
 
2

2GWLAN

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!
Click to expand...
Thanks,

Phil Elmers

KARL DEWEY said:
from each record of the Wire_Label_QTY field.

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


2GWLAN said:
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 said:
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


:

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?
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

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

--
KARL DEWEY
Build a little - Test a little


2GWLAN said:
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!
Click to expand...
Thanks,

Phil Elmers

KARL DEWEY said:
But it loaded the query with 8 copies in every instance; not the 4, 6, or 8
Click to expand...
from each record of the Wire_Label_QTY field.

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


2GWLAN said:
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



:

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


:

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?
Click to expand...
Click to expand...
Click to expand...
 
2

2GWLAN

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 said:
Check and see if [Wire_Label_QTY] and [CountNUM] are number fields.

--
KARL DEWEY
Build a little - Test a little


2GWLAN said:
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!
Click to expand...
Thanks,

Phil Elmers

KARL DEWEY said:
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


:

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



:

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


:

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?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Mail Merge Record Every Time 5
Customized Label Template Transfer 1
How to combine two column labels in a pivot table 1
2 Labels per record 3
MailMerging for Labels 0
Duplicate records 1
Need Help Combining Records with Duplicate in some fields 0
Access Query - "Duplicate Records Selected" 5

Top