Repeat labels a Specified Number of Times for a specified record

G

Guest

Hi,

I have a report that creates a label based on fields from a table. The
labels are specific to one record (patientid). previously i had tried a
solution goven ojn this site by adding a table called tblNumbers; not to join
the tables, but rather to just use it to force thirty labels per page. The
prblem becomes, that then there is more than one primary key per record, and
the code doesn't know what it is suppose to bring up, so it brings up 30
labels per page of every record. not what i need.

so, does anyone know, how to repeat a specific record, 30 times on one page
using code?

thx.
fascal
 
M

Marshall Barton

fascal said:
I have a report that creates a label based on fields from a table. The
labels are specific to one record (patientid). previously i had tried a
solution goven ojn this site by adding a table called tblNumbers; not to join
the tables, but rather to just use it to force thirty labels per page. The
prblem becomes, that then there is more than one primary key per record, and
the code doesn't know what it is suppose to bring up, so it brings up 30
labels per page of every record. not what i need.

so, does anyone know, how to repeat a specific record, 30 times on one page
using code?


What is the report query's SQL statement?

How are you opening the report?

How do you identify the desired record?

Lacking that information, I can only provide generalized
suggestions.

Set the query's criteria to the one record.

Alternatively, a better way is to open the report using the
OpenReport method's WhereCondition argument to filter the
report to the desired record.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top