How do I get labels to print to an amount in a table.
ex. shipping 2 boxes with same info cust, prod, qty,... want 2 labels.(next record has a different qty)

Hi Friends,
             Can we add column in report dynamically. Our requirement is we
have to show report as per the Recordset we get, which may change as per user
selection.

Hi, got one question answered today, which I thought would solve all of my
problems, but unfortunately not.
Basically, I have created a report based on a table, which has links to
other tables,  when run the report duplicates certain records and I am not

I know it's sad posting on Xmas day but I'm on a cruise ship in the middle of
the Indian Ocean and there's not much else to do!!!
I have a report based on a qry "qrySalesV2", in the header is a Date/time
control "txtqtr2" based on a date/ time field txtmonthlabel and I'm

How do you put an ampersand (&) in a label a report or form?  I'm sure it is
some brain-dead simple explaination, but I seem to be having a brain fart at
the moment...  Any help will be appreciated..
Hanksor

Can you shade every other record in a report?  I have a report that lists
infractions done by students.  It would be nice to separate them with every
other one shaded at say 15%.  Is this possible or will I have to settle with
adding a dividing line between each record?

In a report, can I pick between a home or office address to print based on
Send To field of O or H?

I have a report written in word that contains a number of tables....I copied
those tables into access reports and got the data to line up accordingly
using access...I then went to export the tables (with the data) back into
word and the only information that was exported was the ...

Hey guys/gals,
Has anyone here had any sucess in programmatically exporting/printing a
multiple page report into separate PDFs.
I've got a report that list invoices.

I have book details stored in a table and would like to create a catalogue
in word format for them. I have the following fields in the table -
AuthorFirstName, AuthorMiddleName, AuthorLastName, Title, Description.
I want the layout to look as follows

I have a form which users can use to open a report.  They can select program
values from the [programvalue] field, then click the "view" button, which has
the following OnClick:
For Each varselected In Me.programvalue.ItemsSelected

I have created such a report in the past showing quarterly results but the
quarters reported change based on the dated selected in the query.  I can't
remember how I did it.  My reort shown unbound fields for each of the field
names in my crosstab query.

I'm using =Count(*) in a report footer to count the total number of records,
but I'm getting a #Error result. What's wrong?

I have about 30 reports and the format is identical for all of them.  Is
there a way to develop (for lack of a better term) a master report that
controls all 30 reports?  So for example, I add a field to the master, it
will add it to all 30 reports, or if I resize a field, it ...

Our new invoice report RptINVOICE has the following headers:
ReportHeader
PageHeader
A DeliveryAddress header