If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I Print multiple records in a report depending on a value .
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. |
#2
|
|||
|
|||
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 "Clark" wrote in message ... 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. |
#3
|
|||
|
|||
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 "Duane Hookom" wrote: 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 "Clark" wrote in message ... 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. |
#4
|
|||
|
|||
How do I Print multiple records in a report depending on a val
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 "Duane Hookom" wrote: 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 "Clark" wrote in message ... 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. |
#5
|
|||
|
|||
How do I Print multiple records in a report depending on a val
Could you share a little about your tables and the SQL view of your query?
-- Duane Hookom MS Access MVP "Melanie" wrote in message ... 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 "Duane Hookom" wrote: 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 "Clark" wrote in message ... 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. |
#6
|
|||
|
|||
How do I Print multiple records in a report depending on a val
Hi Duane
I referenced it directly to the table and it works now thank you so much. Regards Melanie "Duane Hookom" wrote: Could you share a little about your tables and the SQL view of your query? -- Duane Hookom MS Access MVP "Melanie" wrote in message ... 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 "Duane Hookom" wrote: 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 "Clark" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem printing multiple records | Using Forms | 2 | February 14th, 2005 10:11 PM | |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |