I have several reports that display a date using the Date() function
formatted.  When I view the reports in the .adp, I see the date formatted
properly.  But when I compile it into an .ade and run the reports, the field
displays as #Name?.  I know that this is often associated ...

I have a report in which one column consists of numbers. I want to have them
automatically change to an assigned word, i.e. 1 is "wordone", 2 is "wordtwo"
etc. I don't want to see the numbers at all. I don't know if it'll need code
or what. (Don't ask why I need this, I don't ...

I have a report based on a query that prompts me for an employee number.
Upon entering an employee number, the report will display all work orders
completed by that employee along with the parts used with the work order.
I would like to display totals in the report header that will ...

A macro to sent query by form data to a report works. But when I try to use
VBA code to replace the macro I get an error. The error states that using
OutPutTo is not alowed with a report. How can I convert the marco to VBA code?
TIA

in my report there are two controls which i use to delimit the beginning and
end dates for which the report was generated, "Audit Report between date1 And
date2".
my control source for the first is Forms![Print Report].Earliest and for the

How do I keep a subreport together on one page in a report?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

I am trying to create a report in Access. The report contains 8 subreports. I
would like to be able to ask Access to keep a Subreport together on one page
when printing, insted of printing the title of the subreport and one record
on the first page and the rest of the records for ...

I am trying to create a database to organize data about who has signed in to
a place, what date and time, why, etc.
To show why they signed in, I made a separate table and made a list of
possible reasons to put in a combo box. It works fine, and the reasons show

I have a database with 18 fields.  I have data for the first three fields in
all records but only some records have any data in some of the remaining 15
fields (and always different fields).  How do I prepare a report that will
only print the fields that have data?  In other ...

I have a subreport whose Record Source properties as a SQL query. One of the
items is sorted ascending by name. When I execute the report by itself, all
is sorted properly. However, when embedded in a parent report as a sub, it
doesn't sort at all. What's wrong please, and how do ...

I want to take printout of access report design without any data pulling from
the database. Print function in Access Report prints data and not the actual
design of report. Can any body help?

Help, please!  I have a report which pulls from two different tables through
a query.  It pulls the company from the first table and from the second it
pulls investors detail information for that specific company.  I would like
to be able to have this report print screen in the ...

I have to print a specific report (form letter) based upon the value of the
data in field RESULT_CDE.  The user executes this form, and upon entering a
code "20" to print Finding letters, it falls through the logic for reading
the DB2 table, inspecting field PRTNO_NUM for code 20 ...

Any way to do stacked column charts in Access?  I'm using Access 2K, and
didn't see that option in the chart wizard.  I'm wondering if anyone has
figured out a way to do it or if there is a workaround.
Thanks.

I'm in the page header field, If I highlight all the headings is there a way
to change them all to upper case, to save retyping.
Thanks,
kfh.