I have a report that has a field with either the value A or B.  I need to
display one paragraph when the value is "A" and a different paragraph when
the value is "B."  There will always be one of these two values in the field.
Is there a way to do this without creating two ...

I have a report which has many records for each File # and need to add a
subreport because the data I need to display on the report has only 1 record
for each File #.  I have inserted the subreport with the links as follows,
but I cannot get any of the data from the subreport to ...

I s there anyway to setup an automatic report?  Something that runs
automatically?  possibly through scheduled tasks?  A macro maybe?

I have nearly fully completed a database which is mostly VBA although is full of forms. The user opens the form and scans through the records. I want the user to be able to print off the exact record that he is on. In order to do that, i need the report to open on the record ...

I have a NET field & a GROSS field - both are numbers. I run a report where I
group that data by a third field and query the data by date. This is my
problem. I need to in the footer of the groups (via third field in the
report) to calculate off the sums of my query.

I'm editing a report. I added grouping on the field [Subj] and added [Subj]
to the underlying query. If I run the query it works fine. When I open the
report it prompts me to enter a value for "Subject".
This is driving me nuts... please make it go away...

not sure what though.  i have a report that i am trying to create.  i get all
the numbers that i am supposed to except for one.  this one number is
supposed to be a sum of a field withing a certain date range, for a part
number.  i am getting an answer of 1292 when i should be ...

How can I change the caption of a report to data when run?
I have tried,
Me.Caption = [EventSubcategory]
but that doesn't work.

I would like to create a report that brings up rows of data.  Then I would
like to be able to click on one of the fields to bring up a form to change
the data for that record.  My example is I have multiple request numbers.  I
run a report that shows me all the requests for a ...

I am using access 2003.  I have been printing creating a
printing lables since access95 with no problem.  Now using
avery 8160 mailing label definition, I can only print 27
labels to a page.  I cannot get 30 to print.  Does any one

I need to use something similar to sumif from excel in an access report. for
example on a table I have colums showing base fare and the currency code the
ticket was booked in in another column.I want to sum the base fare by
currency within the report. Currently I export the query ...

I would like create reports for the following, would appreciate if someone
could let me know what is wrong with my code, because the report just ignores
the selection values. Thanks a lot!
1. Select date between [date] and [date].

Created a report for labels using Avery 8160 which has 10 rows of 3 labels
each. Print preview shows only 9 rows of labels per page.  How can all lables
on the page be used?

In a query I have
[Project] [Starting Month] [# of Months] [Product]
[Quantity] and the calculated [QM]
Calculated Field [QM] = [Quantity]/[# of Months]

I have the data in a report
Project:        [Project1]
Starting Month: [Starting Month]
# of Months:    [# of Months]