I have made a query with 3 fields: linenumber, weeknumber and quantity.
When I make a chart in a form (with the wizard), I get for every line a chart.
In this chart the quantity is visible for each week.
When I try to make a chart in a report, I get all lines in 1 chart.

I have two tables that are linked together by primary Key, (Detail Driver and
Summary Driver Records),  Each record type has Driver Name, Owner Name and
Interested Party Name for EACH record type.  There may or may not be Summary
Records for a Detail record, (1 Car accidents).  

I have a report working from a fairly involved query, and then I have
the launch of the report build a filter string based on selections
made off of a form.  
The unique piece of data for each record in the query is called

I am trying to create either a command button of macro that when clicked will
send a report to the print dialog window so that the user can select a
printer and change options as needed.  I am not very familiar with Access and
have tried using the command button wizard, but it ...

How to build report with autolookup that fills in fields pulled from table
after I enter a quantity and part number?  Like entering an order for a
product by part number.
Thanks

I am trying to run a 'Total Sales by Day' report from a crosstab query.  The
crosstab query is based on an underlying query which normally works fine, so
long as data exists for each day of the week.  However, problems occur when,
for example, I adjust the underlying query to ...

I have an Access database that has had some 40 reports imported into it.
These reports have groupings with sums in the footers.  Some of the reports
have as many as 7 groupings.  The field names in the database have
consequently been changed from CurrentValue to CurrentValueSterling ...

Can someone lead me in the right direction.
What is the best format for an image to be inserted in a report?
Thank you in advance

Hi, after running a query with Access 2003, I save the query as a report.  
How do I design my report to show only one field label per column and the
lists of all the field information that pertain to the column?  I would like
to see the report just like it appears in the query.

I have a join query I use to pull information for statements.  I would like
to include a description from the first occurance only of the invoice
details, but when I run the report, it reflects as many lines as there are
line items and posts (and adds) the invoice total as many ...

How do I create a report to show two subreport one after another. What I
mean is the first Subreport will show all its records, then the second
report will show all it's record. This is in the same report. I have tried
the inserting the subreport using toolbox, but the display is a ...

Although I have no problem running reports or viewing them on my workstation,
when I distribute it to other workstations users cannot print reports and
cannot look at their design.

I am trying to add in literal single-quotes around the parameter
@vchDistrictName in the following line. Any suggestions?
SELECT @SQL = @SQL + ' WHERE District.DistrictName = ' + @vchDistrictName

Hi, I won't go into the agonizing, but I think in the process of working
through our project we have found a bug with Access.
Basically, I have created a report based on a table, which has links to
other tables,  when run the report duplicates some records and I am not sure

       So, round two...
       I have a report that is opened by a "pre-report config" form, where I
set various formatting things.  When I open the report, in its Open event
code, I refer to various controls on the "config form," and set things like