Can anyone help me with an approach on how to do this. I know I can select a
query and then use Export under the File menu, but I need to do this task
just by clicking an button. I know a little about access vb code so if
someone could give some hints on how to perform this kind of ...

I have a report based on the results of a query.  The query (and therefore the report) asks the user for the Order ID then displays all part orders (items) and their costs.  Is their a way to add all these together?
Ask if that's unclear...
Any help would be appreciated,
Samantha ...

i have a form. inside the form i have a text box & a command button. the command button runs a query based on the value user puts inside the text box. i need to see the ouput as a report, right now, as it is based on a query,it is coming as a query output.
can i do it with access, ...

I would like to write a procedure for a report which could provide the
following:
if the footer of the group finishes within the upper half of the page, the
next group should start on the same page; if the footer of the group finishes

Is there a way if I already have a report made and I want another to look
exactly like it that I can use that report and base it on a different query
and save it?  I know there is a way you can save the format in autoformat,
but that only saves fonts and colors.  I want the ...

I am trying to total percents in a report.
I have an underlying table with the fields [CurrentRent] and
[IncreaseAmount]. In a report query I have created the expression field
NewRent:([CurrentRent]+[IncreaseAmount]) and the expression field

I've created a report in MSA2000 using public variables. When i executed the report using MSA2003 it seems as the public variables are not recognized.
Public pfiller1, pitemno as string.
Option Compare Database
Private Sub Report_Open(Cancel As Integer)

What would be the easiest / best way to export data to Excel where records
are exported at the end of each month. A main Excel file needs to pull that
information from each month and display the data for all months year to date.
I guess you could call it an accumlative file.

I have a report that totals the number of members that payed their dues,
that works in Access 2002.  However, when I try to run the report in Access
2003 it doesn't print the total, it does print the rest of the information.  
What am I doing wrong in Access 2003?

Access97
I have a stock usage report based on a table which includes the fields
[Qty] and [SOH].
I would like to be able to present in the report only those records

I writing a report that needs the LASTNAME to be in capital letters....
could someone tell me how to properly use the UCase function (when,
where, & how) or some other function.
Thank you,

       I have a report in which I'm keeping a running count in the detail
section.  For some reason, I don't understand, the count gets incremented
when going to a new page.  I have an OnRetreat event function, but it
doesn't seem to have any effect on this problem.  Can someone ...

The crosstab query I formulated had the start and end date in the parameter
list. However, when I tried to use the report wizard there were no available
fields listed. When I tried to use the AutoReport Tabular I received this
error: The Wizard was unable to generate fields from ...

- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1

I have a sub report in a footer on my main report (footer called
AgencyName Footer) when there is no data in the sub report, I want the
footer to be hidden, does anyone know how to test for no data in a sub
report.