I have added fields to the table a report is built on that needs to be
updated. Help says "Click Refresh on the field list toolbar". I can't find
the field list toolbar.

I've followed instructions in the Microsoft Knowledge Base to create
subreports with concatenated fields that then plop the results into my main
report. It works beautifully but with one small problem. No matter where I
place the subreports - which are set to 0" high and 2" wide, ...

When I use my form to create a request for the information, I receive the
previouse information.  When I use it the second time, the correct
information comes up.

Happy New Year to all of you and special thanks to all the Access MVP...
New year: New issue...
I have created a report (mail merge type of report). Everything works just
great ... BUT....

I run Access 2003.  I have a report that lists a pet owner and their
address in the name header, then lists multiple pets in the detail
section.  I am trying to list the pet owner's phone numbers in the name
header, but when I do this, it lists each pet the number of times that

OOPS!...Hit something as I was typing that made it post...Here is the
"complete" post!
I am not getting a control on a report to sum properly.
Groups are as follows:

One of my reports lists upcoming appointments. I want to appointments for the
coming week to "stand out". How do I do this?
I always have problems with figuring out how to direct Access to do
something-or-other based on dates.

I have a report based on a form with the text-box controls on both being
indentical. The controls on both the report and the form have the same table
as their control source. My problem is that when I update or other wise
change the text-box controls on the form the text doesn't ...

Firstly thanks for helping me and wish you a great New Year
I have a form that contains 5 different reports with command buttons"Print",
"Preview" and "Cancel"
Now everything is working fine only problem is when i select 1 report and say

I am faing issues with command button, I have a small window that pops up
when view reports option is selected from swicthboard.
Now in view report I have 5 different reports, I wld like to create 1 single
"Preview", "Print" and "Mail Report" command buttons for all the 5 reports.

I would like to force the last name to appear on the second line.  Two text
boxes, lname below fname, doesn't work because I have subreports on the same
line which causes the lname to appear below the subreports.
Is there anything wrong with the following code:

I used Allen Browne's template - thanks Allen. I have a dotted line in the
footer to assist in cutting the slips apart.
When I preview (and print) the report, some pages print fine and on others
the data is shifting up on the page. When a page is incorrect, the dotted

Is it possible to retreive the descrion of a field in a table, in a report ?
Best regards

I have a 4 page report.  They are follow up letters that go to certain
clients.  Often only 3 of the 4 pages need to be printed because of null
values in certain fields.  Is there a way to filter printing to only those
pages that have data and not print the blank "Null Value" pages.

I have a simple Table called tblCustomers and a field in there call Status.
The values of Status can only be A, B, C or left blank (null)
I have made a Pie Graph that shows the breakdown of the number of each Status.
the Report name I called 'rptCustomersStatusGraph'