printing single record

[k]

hi!

in forms is it possible to print single record multiple
times on a page?

thanks for any help

 

[Michel Walsh]

Hi,


Definitively, either through an appropriate inner join with a driver
table:


SELECT a.*
FROM a INNER JOIN iotas
ON a.qty <= iotas.iota



where iotas is a table, with one field, iota, with values from 1 to 1000
(say). Use that query instead of the initial table, a, for recordsource of
your report,




either with the report variable MoveLayout and NextRecord.




Hoping it may help,
Vanderghast, Access MVP