How do I design labels w same queried record repeated in Access?

[Marian]

The issue is repeating the same record on a sheet of labels, like a return
address. I am querying one record from database table, then printing an
Avery sheet from a designed Access report with the same labels. Otherwise, I
will have to export the answer table to Word and merge into a label template
that I created which omits "Next Record." Since I will be doing the query
repeatedly with a line of people, a fast turnaround with fewer steps will be
necessary.

 

[Duane Hookom]

If you want to create 30 copies of the same label then:
Create a new query with SQL like:
SELECT TOP 30 msysobjects.Id
FROM msysobjects
ORDER BY msysobjects.Id;
This should return 30 records. Save the query as "qsel30".

Add this query to your report's record source and don't join it to anything.
This should create 30 records for each record in your report's record
source.

 

[Marian]

Thank you. I will give it a try. I haven't used SQL in a long time. I was
a Paradox fan before Access was developed, but I am starting to utilize
Access beyond Intermediate level lately.
THX

 

[Mike Painter]

Thank you. I will give it a try. I haven't used SQL in a long time.
I was a Paradox fan before Access was developed, but I am starting to
utilize Access beyond Intermediate level lately.
THX

The Access developers handbook is a valualbe tool and this might be the time
to pop for a copy.

It has a more complex method for doing this but allows you to select the
number of labels for each record.

bookpool.com has always had excellent prices.