I'm having a problem in Access and can't figure out what's going wrong.  I
have a form where the user selects something from a drop-down list then they
click on "generate report" and it should just show the items on the report
that correspond to the name.  It's not working...  ...

I am hoping for a miracle worker out there.  I have spent days trying to
figure out how to use the where clause to print one record for a report.  I
can't think of anything else to try.  Below was my final attempt.
The report is based on a query from two tables.  My first thought ...

I am going to try and explain this the best way I know how....
I have a database that has a total named OB and a table named ER and a table
named Surgery.  Within those tables I have questions that are check boxes.  
If the check box is checked then a -1 populates.  I then created ...

When displaying several fields from a query in the Detail section, the
information is shown diagonally instead of horizontally. Why is that and how
to correct it?
thank you.

I created a random serial no. in a text box (Text box 89) in an Access 97
control form.  I would like to reuse that number thoughout the report.  Can I
use the printing variable I created that prints out to display elsewhere on
the report?  If I just copy the text box, it ...

I have created a report in access and want to shade every other row for
better visibility.  I am currently using Access 97.

My report displays as follows:
Time   Group     Name
7:00      1         Brown
7:00      1         Smith

How do I calculate values in a field on a report detail?
First I have database fields called FabricBasePrice and FabricRiserI. The
report recordsource is DB3SET.*, along with fields ID, and Inactive.
In a text box on the report detail, I have the Controlsource as

I have a report with a Column Header, Subreport as for Detail, and a Column
Footer
HEADER [Client Field]
DETAIL - Transaction Information SUBREPORT

I need to run a report based on the category the reader
selected. After the reader select the category from the
list box, hit the preview report button. I want to show
the report only for that category not whole category. I am

Hi -
I am trying to format my report such that it displays data
in Columns, rather than rows.
So for example, I have all the attributes listed for Part

I created a report...probably not the best way...it has a
sub report on one side that list a breakdown of
information for my chart and on the right side is a pie
chart. Each is based on it's own query. In each query I

I need to renumber the starting page of a report that is 5
pages to start at 7.  I've looked at the material in
online help, but all that I've seen is how to renumber
reports that are grouped.  My situation is different. I

I try to create a report in Access 2003, but it keeps telling me it's unable
to do so.  I  also cannot open the design view to create one.

G?day All,
I have a report that writes out the data for a quote of items i.e. quantity,
product, packaging, price, total for item, etc.  All my data for the quote
comes from a query related to the tables