How Do I change the Number of copies from a Record Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several records and each record needs a different number of copies
printed. I have the number of copies in a field and would like to snd that to
the number of copies to print for each record.
 
Create a table of numbers with a single numeric field and values 1 - your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with any
other table. Add the Num field to the grid and set the criteria under it to:
<=[NumOfCopiesField]
 
I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field within the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the Properties field!

Duane Hookom said:
Create a table of numbers with a single numeric field and values 1 - your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with any
other table. Add the Num field to the grid and set the criteria under it to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

Bill James said:
I have several records and each record needs a different number of copies
printed. I have the number of copies in a field and would like to snd that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
 
Did you create a table as suggested and add it to the Record Source of your
report? Did you do the other steps? If so, what was the result? If not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

Bill James said:
I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the Properties
field!

Duane Hookom said:
Create a table of numbers with a single numeric field and values 1 - your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with any
other table. Add the Num field to the grid and set the criteria under it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

Bill James said:
I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
I think you mis understood whta I need
I would like to send to the print that number of pages based on the number
in the number of copies field. I do not need to show the number of copies on
the report.

Duane Hookom said:
Did you create a table as suggested and add it to the Record Source of your
report? Did you do the other steps? If so, what was the result? If not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

Bill James said:
I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the Properties
field!

Duane Hookom said:
Create a table of numbers with a single numeric field and values 1 - your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with any
other table. Add the Num field to the grid and set the criteria under it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
I assumed you have a table/query with one of the fields being
[NumOfCopiesField]. If the value of this field is 3, you would like to print
3 copies of that record. If the value is 1, you only want to print 1 copy of
the record.

I'm not sure why you introduced "pages" to this thread unless you print one
record per page in which case the above should be true.

--
Duane Hookom
MS Access MVP
--

Bill James said:
I think you mis understood whta I need
I would like to send to the print that number of pages based on the number
in the number of copies field. I do not need to show the number of copies
on
the report.

Duane Hookom said:
Did you create a table as suggested and add it to the Record Source of
your
report? Did you do the other steps? If so, what was the result? If not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

Bill James said:
I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the Properties
field!

:

Create a table of numbers with a single numeric field and values 1 -
your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with
any
other table. Add the Num field to the grid and set the criteria under
it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to
snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
Ok I understand wht you are doing. What is happening is the records are
duplicating too many times. For the first record I need only 3 and I am
getting
89 Records

Duane Hookom said:
I assumed you have a table/query with one of the fields being
[NumOfCopiesField]. If the value of this field is 3, you would like to print
3 copies of that record. If the value is 1, you only want to print 1 copy of
the record.

I'm not sure why you introduced "pages" to this thread unless you print one
record per page in which case the above should be true.

--
Duane Hookom
MS Access MVP
--

Bill James said:
I think you mis understood whta I need
I would like to send to the print that number of pages based on the number
in the number of copies field. I do not need to show the number of copies
on
the report.

Duane Hookom said:
Did you create a table as suggested and add it to the Record Source of
your
report? Did you do the other steps? If so, what was the result? If not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the Properties
field!

:

Create a table of numbers with a single numeric field and values 1 -
your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it with
any
other table. Add the Num field to the grid and set the criteria under
it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to
snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
Apparently you didn't set the criteria in the record source to something
like
WHERE [Num] <=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

Bill James said:
Ok I understand wht you are doing. What is happening is the records are
duplicating too many times. For the first record I need only 3 and I am
getting
89 Records

Duane Hookom said:
I assumed you have a table/query with one of the fields being
[NumOfCopiesField]. If the value of this field is 3, you would like to
print
3 copies of that record. If the value is 1, you only want to print 1 copy
of
the record.

I'm not sure why you introduced "pages" to this thread unless you print
one
record per page in which case the above should be true.

--
Duane Hookom
MS Access MVP
--

Bill James said:
I think you mis understood whta I need
I would like to send to the print that number of pages based on the
number
in the number of copies field. I do not need to show the number of
copies
on
the report.

:

Did you create a table as suggested and add it to the Record Source of
your
report? Did you do the other steps? If so, what was the result? If
not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field
within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the
Properties
field!

:

Create a table of numbers with a single numeric field and values
1 -
your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it
with
any
other table. Add the Num field to the grid and set the criteria
under
it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

message
I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to
snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
Thanks you for your assistence
After trying it several times and then understanding what u said the first
time I was bale to get it to work
=[tablenum] is waht finallay worked for me.
Click to expand...

Duane Hookom said:
Apparently you didn't set the criteria in the record source to something
like
WHERE [Num] <=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

Bill James said:
Ok I understand wht you are doing. What is happening is the records are
duplicating too many times. For the first record I need only 3 and I am
getting
89 Records

Duane Hookom said:
I assumed you have a table/query with one of the fields being
[NumOfCopiesField]. If the value of this field is 3, you would like to
print
3 copies of that record. If the value is 1, you only want to print 1 copy
of
the record.

I'm not sure why you introduced "pages" to this thread unless you print
one
record per page in which case the above should be true.

--
Duane Hookom
MS Access MVP
--

I think you mis understood whta I need
I would like to send to the print that number of pages based on the
number
in the number of copies field. I do not need to show the number of
copies
on
the report.

:

Did you create a table as suggested and add it to the Record Source of
your
report? Did you do the other steps? If so, what was the result? If
not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field
within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the
Properties
field!

:

Create a table of numbers with a single numeric field and values
1 -
your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it
with
any
other table. Add the Num field to the grid and set the criteria
under
it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

message
I have several records and each record needs a different number of
copies
printed. I have the number of copies in a field and would like to
snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
Glad to hear you got it working...

--
Duane Hookom
MS Access MVP


Bill James said:
Thanks you for your assistence
After trying it several times and then understanding what u said the first
time I was bale to get it to work
=[tablenum] is waht finallay worked for me.
Click to expand...

Duane Hookom said:
Apparently you didn't set the criteria in the record source to something
like
WHERE [Num] <=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

Bill James said:
Ok I understand wht you are doing. What is happening is the records are
duplicating too many times. For the first record I need only 3 and I am
getting
89 Records

:

I assumed you have a table/query with one of the fields being
[NumOfCopiesField]. If the value of this field is 3, you would like to
print
3 copies of that record. If the value is 1, you only want to print 1
copy
of
the record.

I'm not sure why you introduced "pages" to this thread unless you
print
one
record per page in which case the above should be true.

--
Duane Hookom
MS Access MVP
--

I think you mis understood whta I need
I would like to send to the print that number of pages based on the
number
in the number of copies field. I do not need to show the number of
copies
on
the report.

:

Did you create a table as suggested and add it to the Record Source
of
your
report? Did you do the other steps? If so, what was the result? If
not,
where did you not understand the steps?

--
Duane Hookom
MS Access MVP
--

I am a little confused about the instructions
I have an existing report
I want to print x number of pages for each record
Each Record already has the number of pages I need to in a field
within
the
table

What is the reason for the new table?
I have tried to ad this as a parameter to the report in the
Properties
field!

:

Create a table of numbers with a single numeric field and values
1 -
your
maximum number of copies.
tblNums
Num
1
2
3
4
5
...
max
Add this table to your report's record source and don't join it
with
any
other table. Add the Num field to the grid and set the criteria
under
it
to:
<=[NumOfCopiesField]

--
Duane Hookom
MS Access MVP
--

message
I have several records and each record needs a different number
of
copies
printed. I have the number of copies in a field and would like
to
snd
that
to
the number of copies to print for each record.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top