Duplicate records

  • Thread starter Thread starter manju
  • Start date Start date
M

manju

Hi, i have gone through all the posts in this discussion group.
I need help with lables, i have records in a table like below
Orderno box qty
23456 5
23412 1
45632 2
for everybox i need to attach the label stickers that im going to print, but
it has to print labels as the num of boxes, im using ms word to print labels
which will get the data from access.
pls help me with this query
 
Have a driver table, call it Iotas, one field, its primary key, iota, filled
with integers values from 0 to, say, 99 (or whatever limit fits your needs).
Here a possible SQL statement:


SELECT OrderNo, BoxQty, Iotas.iota
FROM yourTableName INNER JOIN iotas
ON yourTableName.BoxQty > Iotas.iota




Alternatively, graphically: Make a new query, bring the two tables, DO NOT
JOIN the tables, bring the required fields in the grid, and, under the field
BoxQty, add the criteria:
[Iotas].[iota]
Click to expand...



That's all.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top