Hi I have a text box which I want to pick up the data from field1 if this
IsNull (blank) then I want it to pick up the data from field2. When the
report opens, how do I go about it?
I have tried the following on the reports open event.

This is one of my first reports I've put together, so bear with me if I'm not
providing the information you need.
I've created a report rtpInternaltoPrimary based directly off the table
tblInternaltoPrimary.  In the report, I've Grouped by the field "Summary".  

Good day everyone,
I have a report in Access XP that I am trying to save as a Data Access Page.
When I save it, I give it a new name (with no spaces in the file name) and
the Save As type as HTML but then I get:

I had to delete a query that I was using to produce a report in access?  I
remade the query with the exact same fields.  Is there a way to "reattach"
that query to the report?

New member here. I'm attempting to create a report from a query. The query is
built on two crosstabs and 3 small select queries, all joined by
"InspectorName". The query itself produces the exact desired result, and runs
beautifully. However, when I try to create a Report, Access ...

I actually have two questions:
I'm trying to print a label(s) in Access and would like to be able to print  
"1 of 2", "2 of 2" etc on the bottom of each label. The user would need to
input the number of label they require, and then that would determine the "

When I run my report I am presented, as expected, with a history of an item.
How can I print the current record shown instead of all records?
Regards
John

Please help.  I'm stumped.
I have a report with three columns of data calculated from a fourth column.  
I can't get them to total in the report footer.  I keep getting a prompt for
a parameter value. The report looks something like this:

Dear all,
 I am having error when running the sum e.g.  =Sum([A])  , the value of [A]
will be 0 or null. I tried: sum(Nz([A],0)) and Nz(sum([A]),0) , but both
still got error on it. can anyone give me a hand?

I have a report with a query data source.  I can place all the fields on the
report and they print just fine.  What I want to do is use 10 of the fields
in a calculation in code in the  "detail on print" section.  I don't what the
10 fields to print just the calculated string.  ...

I have to use a matrix printer to print my invoices.
I use a OKI Microline 380 matrix printer.
Everything works just fine except that the printer prints high quality
instead of draft (time to print is twice as long too... high quality

I have a form with the following code in a command button.  I would like to
print that current record onto a report.  It prints out the record on the
report but it also prints the all the records form the form.  Does anyone
know what I'm doing wrong here?

I need to fill out a with 10 lines, using data for each line from a combo box
on a form.   I will be filling out a form with employee information into a
specific spot on the form for each combo box field.  how do i do this?  I
have not created anything yet and I have Office 2003. ...

Can I add a command button in a report?I tried to do so but the wizar
didn't start.Any ideas?Thnx
--
skiabo

Hi I print to cut sheet labels.  The usual problem is that if I only print
say 6 labels on a sheet of 12, the balance are usually wasted, as Access
will always want to start at top left hand label.
I didn't know if anyone had come up with a way to get round this problem.