I have an Access 2003 report that needs to request a date value from
the user whenever it is opened. This date value does not have to be
saved in the database, but it does need to display in the report.
Any help would be greatly appreciated. Thanks.

I am prompting for input(the month) for the header, and it works unless the
results of the query has 0 records. Then it turns into an error. Is there
another way to do this?

Is there a way to use the Count expression in a report so that I may be able
to obtain the total number of a particular input in a column?  For example,
if I have a column which contains student marks, in the Text Box control
source I could enter an expression like:  ...

Dear Professionals:
In my table my fields are:
Salutation
FirstName

I have a sum of vacation hours on a report.  I do not want the "total"
number of hours that I track to go over 240.  How can I do this?
Thank you

Please tell me what is wrong with this line:
=CanShrinkLines([CONTENT 1],Trim([CONTENT 2]),Report!WIDTH,[PRICE 1])
The following Microsoft knowledgebase article told me to create a single
textbox with the abovementioned line as the Control Source if I want to

I need to permanently save a report on a weekly basis (no overwriting of
previous reports) in a format other than Access.  When I try to export to
HTML or Word (rtf), all that's displayed is the Report Header and Page
Footer... no data.  I read something in the discussions about ...

How does one go about getting a count of the number of items in a group to
put in the group header or group footer.  (If it is possible at all!)  I
started down the path of DCOUNT, but when the criteria simply has a test to
see if a field is equal to itself, which sort of makes ...

I put a messagebox in the Sub Report_NoData indicating no data for the
selected criteria.  It works great, except that after my messagebox comes up,
another one comes up which says "The OpenReport action was cancelled."  
I tried to turn it off by setting warnings to off before ...

Having an issue just recently that is occuring on multiple databases and all
machines tested so far.
I open an existing database, double click my report, and nothing happens.  I
try to goto design view, and nothing happens.  I try to create a new report,

Hello group -
Using Access 2000 REPORTS
I want to show:
"X records of TotalX"  on each page of a report (x is incremental, TotalX is

I would like to have vertical lines from the report header down to and part
of  the detail section in a report. Is this do-able with out haveing a break
in the lines. Thank in advance.

I need to make a text box (txtfinal) that has an expression like this:
If "txt1" >8, then subtract 8 from "txt1"
and also if lstName is null then txtFinal is null also
"txt1" is a text box from a form that has a mathematical equation on it.  

I have a field in a report of =[Student Name] & " " & [Student Surname] I
want to say that if there are more than 20 characters in that text box then
make the point size a little smaller. I know the lenn formula for the first
part but how do i tell access to make the font (point ...

I have a main report with 2 subreports, 1 for sales orders (with a Calc.
totals fields) and 1 for PO's( With Clac. Totals field). These are then used
to calculate a profit in currency & percentage on the main Report section.
My problem is, that if there are no PO's then the ...