I am trying to create totals on a report and have the following in the report
footer;  Sum([txtEndingBalance]).  When I run it the report asks for a value
for parameter txtEndingBalance.  What is wrong with the syntax?
Thanks

I have found that using concatenated fields in a report's
underlying query can eliminate many of the formatting
issues related to text boxes growing and shrinking.  The
most vexing problem is that if text boxes are arranged one

Does anybody know an easy way to print the record
selection criteria(from a query) in the header/footer of
a report.  Not just the SQL statement, but also any
parameters entered by the user when running the report.

I have 2 types of pictures I'm dealing with.
One is the bitmap (which does print) and the other is a
link to a picture. When it comes up in report print
preview, the picture shows fine, but when I hit print, it

I want to print a memo feild containing text at the end of
every report. The memo feild comes from a diffrent table
than of report query.
I got the solution from one of the access help member, but

I produce a report that has entries that comprise names and details, in
alphabetical order. Each name has a variable number of entries against it in
the form: name, date, day, AM/PM, partner.
I want to print a report that will recognise a change of name and force a

In my report from a crosstab query I have included all fields which can
occur in the crosstab query. Sometimes not all fields are in the
crosstab_query. Which causes a message that say cannot recognize Field X as
a valid field or expression. But I have these fields in the report ...

I am creating a database for an IT helpdesk. I have created a report and i
want the table and the form that it is created from to update a field called
'printed' when I print the report. I have tried the set value function from
the onprint option but nithing works. Am I on the ...

Hello.  I have a report whcih has several fields that are
check boxes and need some help.  I would only like the
fields checked yes to show up with the label and another
label which acts as a "header."  Only one box from each

  On my Access 2000 application, I have an query result
screen, on the screen there is a "Print" button to print  
report. Both screen & report are based on same query.
  Now on the query result screen, it dispaly different

Right now I have an event procedure on The Open of the
Invoice report that declares some integers for late.  
What line of code do I put in to run an update query on
the OPEN of the report.do I just put it right before the

Larry - Thank you for info - Tripod had a brilliant
solution for picture acquisition which place the correct
url into the text field in the table - however, there are
no reports.

How do I create a report from info from multipul queries?
I have a monthly scrap report and want to do one with all
the past monthly reports. In other words...a year to date
report. Any help would be helpful.

I have a report that looks like this:
     Sun  Mon  Tue  Wed  Thu  Fri  Sat  Total  Percent
7:00    4    5    3   12    4    3   11     42    5.45%
7:30    4    3    3   19    1   12   10     52    6.73%

I have a report consist with 9 subreports.  I would like
to skip certain sub report, if the user choose not show
this subreport on a form. How can I do this?
Thanks for any help!