i create a report to print orders, but when i preview the report i found the
first page is ok but the resent pages is not formated, i mean there is no
page footer , the data section ha a little line on the right , my report has
page header and footer, and OrderID header and ...

I have a report based on a query with a text box in the Report Header.  The
text box control source is: ="From " & [Enter Start Date] & " to " & [Enter
End Date]
It prompts me for both dates and displays the dates entered, but pulls all

I have multiple calculated fields whose results return either text from a
memo field or nothing. When the result does not return the text from a memo
field I want the space for that field to close up. The calculation for the
field is done via a Function. Can Shrink and Can Grow ...

I have 5 append queries that enter records into a table.  Each query has a
field that specifies which query the record came from.    The problem is some
people can be entered in more than one query, and they print out multiple
times.  I would like to have a report that prints out ...

I have a report based on a query.
I used the wizard to make the basic report, but then I'm moving a lot of
stuff around to make it look the way I want it to.
I have several layers of grouping.

Need to display pictures on an access report that are stored on an internal
company web site.  Need for the actual pictures to be loaded into the report
or appear on the report when printed.

I am using Access '97 and ran into the problem of needing to print a report
larger than 22".  I have seen this problem in several threads.  Does anyone
have Access 2003 and know if the 22" restriction has been removed?
thanks,

I have inventory list and qty on hand,
For instance:
Item#    Qty
001        18

I have a report based on a query with one field that doesn't show up on my
report, no matter how I try to put it in.  All the other fields are doing
fine.  This is a text field.
When I run the query, the field has data in it there.

I have two tables with the following fields to report:
tblProfiles
txtProfileID (PK)
Description

I'm trying to count a text value for a report.  In one of the report's
controls I have =Count([PhotoID])="Yes".  So I would like to know how many
Yes' there are.
The field is a text field not a Yes/No

I created an application user that has limited privliges.  I gave this user
read open/run and read design permission on all reports.  When I package
the application including the access runtime, the user is unable to right
click on the report and see the send to menu option.  When I ...

This is in reference to a question and answer posted earlier this week
regarding filling the blank fields. The advisor advised that it is possible
to fill the blank fields in report.
I have a report based on a table. Generally many of the fields are blank.

Is there any way to lookup/ count the days between 'startdate' and
'enddate' , work out how many of them are Sundays (non trading days), and
subtract those Sundays from the total days?
That would give me the final figure I am looking for,

I know there has to be an easy answer to this but I can't seem to find it.
I have created a form for my switchboard that contains a dropdown menu for
selection of a particular project manager. I have the command button marked
"OK" perform the following event procedure: