How do I Print multiple records in a report depending on a value .

[Guest]

I am trying to make a report that would print price tags for items. I need
the number of tags printed to be dependent on the field "Quantity."
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags for
chairs and 1 tag for the table.

 

[Duane Hookom]

One method is to create a table (tblNums) with a single, numeric field (Num)
and values 1, 2, 3, 4,...max of quantity.
You can then add this table to your report's record source and set the
criteria under your [Num] field to:
<=[Quantity]

 

[Guest]

Hi Duane,
I read the solution you gave me previously in the knowledgebase but it
didn't seem like it would work. After getting the same suggestion from you,
I tried it and it works beautifully!
Thank you very much!
Clark Baker

One method is to create a table (tblNums) with a single, numeric field (Num)
and values 1, 2, 3, 4,...max of quantity.
You can then add this table to your report's record source and set the
criteria under your [Num] field to:
<=[Quantity]

--
Duane Hookom
MS Access MVP

I am trying to make a report that would print price tags for items. I need
the number of tags printed to be dependent on the field "Quantity."
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags
for
chairs and 1 tag for the table.

 

[Guest]

I have tried this and it comes up with an error ambigious field reference
"Quantities Sold" as that is my field name in my table. would you be able to
help me as i am in stress mode as my demo is tomorrow i have completed the
whole application except for this. i would highly appreciate if you could
help me.

Regards Melanie

One method is to create a table (tblNums) with a single, numeric field (Num)
and values 1, 2, 3, 4,...max of quantity.
You can then add this table to your report's record source and set the
criteria under your [Num] field to:
<=[Quantity]

--
Duane Hookom
MS Access MVP

I am trying to make a report that would print price tags for items. I need
the number of tags printed to be dependent on the field "Quantity."
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags
for
chairs and 1 tag for the table.

 

[Duane Hookom]

Could you share a little about your tables and the SQL view of your query?

--
Duane Hookom
MS Access MVP

I have tried this and it comes up with an error ambigious field reference
"Quantities Sold" as that is my field name in my table. would you be able
to
help me as i am in stress mode as my demo is tomorrow i have completed the
whole application except for this. i would highly appreciate if you could
help me.

Regards Melanie

One method is to create a table (tblNums) with a single, numeric field
(Num)
and values 1, 2, 3, 4,...max of quantity.
You can then add this table to your report's record source and set the
criteria under your [Num] field to:
<=[Quantity]

--
Duane Hookom
MS Access MVP

I am trying to make a report that would print price tags for items. I
need
the number of tags printed to be dependent on the field "Quantity."
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags
for
chairs and 1 tag for the table.

 

[Guest]

Hi Duane

I referenced it directly to the table and it works now thank you so much.

Regards Melanie

Could you share a little about your tables and the SQL view of your query?

--
Duane Hookom
MS Access MVP

I have tried this and it comes up with an error ambigious field reference
"Quantities Sold" as that is my field name in my table. would you be able
to
help me as i am in stress mode as my demo is tomorrow i have completed the
whole application except for this. i would highly appreciate if you could
help me.

Regards Melanie

One method is to create a table (tblNums) with a single, numeric field
(Num)
and values 1, 2, 3, 4,...max of quantity.
You can then add this table to your report's record source and set the
criteria under your [Num] field to:
<=[Quantity]

--
Duane Hookom
MS Access MVP


I am trying to make a report that would print price tags for items. I
need
the number of tags printed to be dependent on the field "Quantity."
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags
for
chairs and 1 tag for the table.