I've been learning access by the seat-of-my-pants at work
here, and I've come across a couple of stumbling blocks. I hope you all
can help. This reports question is actually the simplest of my issues
(I think), but my other issues are with forms and queries/tables, so

I would like to change the sort field for my reports based on criteria
selected on my Report Selection form. For example, i have a report that needs
to be sorted by Customer and by Order Date, but it will vary, depending on
the option selected. How do I change the sort options in ...

I have a report with a header and detail section.  The report is designed like:
Customer Name                      (header)
type       wholesalecost     retailcost       (detail)
And is printed like:

I have tried using the code listed for combining duplicate results
found in a table but have been unsuccessful.  Here's what I have:
SELECT DISTINCT Replace([String],Left([String],3),"") AS Expr1, [DS:
ASU Data].Location

I have a report that is based on a crosstab query, but the fields in the
cross tab query may change depending on the criteria.  Can someone point me
in the right direction as far as how to make the report dynamic in order to
accomodate the fact that the fields in the report may ...

I have an access 2000 database that has a series of OLE object that are
photos. Our graphics department has changed the format of the photos from
jpeg to TIF with lzw compression. Does anyone have any ideas as to how I can
open this type of file in Access and use it has an object ...

My report is displaying the primary key which is an autonumber rather than
the text I need to see. The text is visible in the underlying query, but
doesn't display on the report. What am I doing wrong?  I have an expense
table and an Owner table.  Owner table has two fields, ...

My situation: I have 2 memo fields that may hold only a few lines of text,
or up to a page's worth combined. They are set to auto-grow. Below the
fields, there's some text and a subreport, which belong together but are
separate controls. In order to save paper, there's no page ...

I have 2 text boxes one for street address and one for PO Box address. I have
a report that prints labels of people's addresses and I want to be able to
print the records if the PO Box exists then it won't show the street address,
and if it doesn't exist then it shows the street ...

        I've been learning access by the seat-of-my-pants at work
here, and I've come across a couple of stumbling blocks. I hope you all
can help. This reports question is actually the simplest of my issues
(I think), but my other issues are with forms and queries/tables, so

I have a report with a yes/no field for which I would like to count the
number of "Yes" responses on.  I created a calculated control using an
"IIF " statement.  The formula is written as follows:
IIF ([field name X] = -1, sum[[field name x], 0)

I have a report and subreport.  The report has some information from a
tblProject.  The subreport has information from tblDiaryNotes.  What I want
the subreport to display is only the most recent diary note.  I have tried to
create a query that uses TOP or DISTINCT without ...

I want to design a report that will have 5 numbers displayed across the
page, and 45 numbers displayed down the page.
The numbers will be calculated via a Function (yet to be written).
I'm thinking the easiest way to do this would be to have a single text

I have been to Steven's site, and love the vertical and Horizontal lines
demonstrated.
I just have this one little snafoo, they won't work in a subreport.
Anyone have any idea's how I can make that work?

Hi All! Thanking anyone for a reply. A2003.
I have a 3D split Pie chart with titles & percentages for each category in
my report.
When I view the chart some of the titles are too close together and