I would like to have a page header that shows up ONLY on the second page and
further.  This is because I have a subreport that continues onto the second
page, but will not put its page header on the second page, so the table
continues on the second page without any headers.  It ...

Trying to filter a report by comparing a field value to a list without having
to retype the table name and field everytime - the following works:
[Payments Applied with Groupings Added]![P/A Mess Code 1
Grouping_Grouping]="Additional Information" or

I'm having trouble with this dlookup- I need to bring up a value for the
name of the category rather than its ID. The ID field is a foreign key in
another table and is a combo box , row source EMP Query. Every combination I
try results in an error or a parameter box being put up. ...

On my reports form I've got a report where you can select
from a combo box which company you want to print
information.  Once selected, the page header of the report
has a text field that will display whichever company I

I created a report based upon a query that filters all records with
"a" in a field
I created another based upon records with "C" in a field
Then I created a report based upon the first query. Here I added a

I try to connect to the Report Server Web Service from MS Access 2003 using
the Web Services Toolkit 3.0.
The Web service is found, but when it generates the code in Access I get the
following error:

I've got a report in which I want to display the values of a table.
Basically, it works fine, but I'm only able to show the horizontal lines
of each row. I also want to show the vertical lines of each column.
Since the height of each row differs, the length of the vertical column

I originally posted this in the Excel forum but wanted to throw this in
Access also because I may opt for data import from Excel to Access.
------------
I need code or a formula to return the amount of times text was found in a

The problem is I need no "Group Head" nor "Group Footer"
to set up; because this led to choose for the sorting of
either ascending or descending.  But to do so, I still
need the "sum data" to be sum as at the end of the line as

I have a detail control named YToD on a tabulating report
with several rows and columns.  In the Report Footer at
the bottom of the report, I want to sum the column with
the YToD control for all rows.  When I enter the

I want to set the number of columns in VBA based on the maximum size of the
data I'm displaying.  Where do I find the "page setup" properties for a
report?
TIA,

I have two tables:  tblOwner and tblHerdInformation.
Fields in report:  Municipality, NumberInHerd, TestingCompleteDate
Issue:
I am trying to create a report where by I have a listing, given a specidic

I'm really chuffed that I've just created my own progress bar on a form
while a complex report with loads of pictures is printing, but this has made
the Print Dialog box ('Now printing page n to the blah printer') a bit
superfluous.

In my report I highlight my field--go to formatting--conditional
formatting--condition 1--expression--then I type in the following--[rKRAT>=1
& <=2] AND [nMLO >=6]
When rKRAT is [>=1 and <=2] and [nMLO>=6] I want to make that field box turn

I am trying to use a textbox on a report as a variable
based upon a select case scenario.  For example select
case 1 the textbox should read field (control source0
{ABC} case 2 should read field (control source) [DEF]