I have a MDE FrontEnd that is distributed to many clients. the clients have
different printers or simply different default settings for their printers
(e.g. duplex or simplex). Why is it not possible that Acc prints the reports
on the default printer with the default printer ...

My report is linked to a table. It lists parts in descending order by cost
with a running sum. In the report header I have GT "=Sum([cost])". Also is
GT80 "=([GT]*.8) and GT95 "=([GT]*.95).
In the detail section I have RunningGT, [cost] is a running sum, and unbound

How do I write code to export a report to excel? I have a command button on a
form that runs the report to excel but it's using a macro. How do I change
this so I don't have to use a macro?

I have a table with MeetingType and MeetingDate (mm/dd/yyyy format
fields. How do I make a report that will allow the user to selec
Meeting Type AND Year?
I'd appreciate your help. Thanks

I have a field in my table for Date (mm/dd/yyyy format). In my report,
would only like to display the month and day from that field. How shoul
I go about it?
Thanks in advance for your help

Is it possible to create labels from a parameter query, but the labels are
all the same.  ie... i would enter a persons name and the labels would output
the name and address for this person on every label?
Thanks

I have the following code that will produce this report to a rich text word
document, once the email button on my form is clicked. When the email button
is clicked, it basically grabs the text from my tblComments / comments Field,
and transfers it to a word document rtf format.

I have a report which I designed to be printed on a legal size paper.  The
report is 80+ pages and has 17+ columns.  
On the report preview screen, when I click on "Analyze It with Microsoft
Excel", it tries to export and save, and once it hits 21 pages, I get an

Looking for more report options than standard fare in Access 2000. With
additional software either from Microsoft or others

I am using the expression @;---- to  fill a blank entry in my reports with
four dashes. The problem that i now have with this is that I also would like
to display the numbers/text in the db in a certain format (I.E. XX.XX) I
have tried playing with various combinations but cannot ...

I have a report with several subreports.  I know approximately how long each
of the subreports will be (usually one page or less) and would like to have
page breaks at points that will allow the full subreport(s) to be on one
page.  

Ok I have included the code that I'm using below. It does work with only one
problem, it will not line up correctly. Now I'm figureing is possebly the
fonts used as they are proportional and fixed width. I could be wrong but
would love to be able to line this up correctly.

I have a check box (true/false) that I want to translate into text on my
report.  I tried putting the code into the sub Detail_Format section, but it
errored out with Object Required on the first line of my code. I also put it
into the sub Report_Open but it had the same error.  ...

I'll try to ask this again in the hopes someone has a solution to the
problem. I want to print a list of items, 1 item per line as show below.
Here is where the problem arises if the value of the item in null or 0 then
I don't want that item to print at all. I also don't want the ...

I know this is a bit of an odd request, but I would like to calculate the
minimum of four distinct values on a report.
I have four fields for each daily record: I1, I2, I3 and I4 there is a value
for each day and I would like to be able to flag the lowest value of the