I have the below code that runs off a command button on
my form. It prints two copies of the report which is fine
but it is actually applying itself to each record so when
i select the command it prints this report for every

Please help me turn my calculated control into a rounded-off number. What is
the proper syntax that i should put in?  Thank you very much.

When I use some functionalties of my Access 2000
application and exit out of the application, I can see
that .ldb file is created. It prevents me from opening my
application again and I have to either save it under

When you click on a report designed from a crosstab
query, can you program it to ask for date parameters?

Whenever I create a report and open it in design view it
shows a default chart with three series, east, west and
north instead of the chart I have created. When I then
flick back to print preview my chart appears.

I am currently trying to print a 250+ page report and am having trouble with
single lines carrying to next page of printed report. I need to eliminate
these occurrences. Can anyone help

I have a main table, payments table and estimations table.
(The ID of the main table equals suitID that exists in
both payments and estimations tables)
I would like to create a report that gives, for example,

I am trying to sum a calculated field.  I have a text box in the report
header and sum([txtEndingBalance]) does nothing but ask for parameter
txtEndingBalance to be populated at run.  sum(Ending Balance) does nothing
either accept give me very ridiculous totals.

My Access Reports are dropping the changes made in Page
Setup to the margins and format and reverting to the
default format which is 1" margin and Portrait format.
How do I set the margin and format programatically.

Hi, I have a table "gender" which contains W and M, how
can I calculate total count of W/M from the table.

I have a report that has a subreport.  This subreport has one level of
grouping.  I have a text box (let's call it Text1) that I want to sum on the
footer of level1 (which is, of course, below the detail section.)  I have
another text box (Text2), whose control source is Text1, ...

Not sure if I can do this or not but here goes. I'm using Access 2003.
I have a report that has these two fields [Date] and [Cost]. In the
query I have parameters in the Date field to run the report Between
[Start_Date] and [End_Date]. I usually run the report for a specific

I have some MEMO fields wich contains HTML code (very simple code, <strong>
<i> lables and so).
I need to print them in a report RENDERED as they would be sown in a web
browser. ?is there any control to do it?

On a form I have a command button that has the code below
in the On Click event. I am trying to print a report. I
have added a MsgBox to see what response I am
getting. "ReportDate" is a text box on the form formated

I'm relatively new to Access, using Access 2000.  I have a simple table with
a few fields.  The two fields in question are fname and lname, both text.
I'm creating a report and I want to concatenate the fname and lname into one
field I'm calling "name".