Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple tags report. 1

Status
Not open for further replies.

Rubius

Programmer
May 12, 2000
57
CA
This is what is happening now:<br><br>I have a query that has a few fields and it has an Item prompt and it asks for the item number and I type it in and it displays the one item field. (one item to one item number obviously).<br>So now we are receiving some inventory and lets say we get 10 of item no. 3030B and we want to print some labels.<br>I have a report made that goes with the previous query and prompts for an item then displays that items tag. Obviously we don't always receive 10 of one item. How can I make it so that the report prints out X number of tags. I want it to continue prompting me for the item no. but I want a second prompt that asks &quot;How many tags?&quot; I'm thinking that I could put a piece of code to on open report but I haven't a clue about the code. <br>Notes: if I open the report and allow all items to display, then it'll put about 6 tags on one page all different items. I want 6 tags per page with the same item. <br>Thanks in advance.
 
Create a table that has 1 field named counter. Open the table. Number the counter field from 1 to what ever you think the maximun amount of labels you will want. Add that table into your query don't link it.<br>drag the counter field to the table and set its criteria to &lt;= [how many tags]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top