I want to make one chart that represents info from all of my records.  I can
figure out how to insert a chart into a report, but there is one report per
record.  This is great, but I only need one chart, not X number of charts.  
How do I set up an environment that will allow me ...

I am wondering if I can create an application that when you click on
it (say a shortcut), it opens a report parameter box to query a set
of
parameters, and then opens the report based on these selections

The detail section of my report has vertical and horizontal lines so that my
values are printed in a table.  This works fine.  But, I want to always print
a few blank table rows at the end of each report.  If there are 20 lines of
actual data, I'd like my table to show 22 rows.  ...

i have a report that is currently using some code to grab a variable from a
form for display on the report..problem is that the underlying data changes
when there is more than one page to display, but it gets the same data from
the same displayed form.

I am trying to set a default value for a combo box that is a  static list
with three items in it. Everything I have found googling has related to
setting the default value in the controls properties using this format:
=[controlname].ItemData(indexnumber)

I'd like to be able to print a report that prints the top 3 of each group.  
However, when I try modifying the SQL to begin with "SELECT TOP 3", I get
only 3 records (apparently those that have the largest DesignerID number).  
Here's my current SQL that lists all records by group:

I'm using Access 2003 (on Windows XP) and have a split dbase (FE/BE) with
security permissions set.  One of my users cannot print preview or print any
reports.  The user is in the same User group as the rest of my end users.  I
went into one of the Access modules on her computer ...

I have the report to display only the record with value...May i know the way?
For example some record might not have value in certain field and I only want
to showed the one with value....
Thank you..

Hi all,
I have a report that has a chart of line graph graphing sales of a
certain prodouct over several weeks of the year and that has a query
as row source.

Hi Groupies
I used the On No Data event on my subreport so that if it has no data, it
does not print. However, if the sub does not print, I also want two text
boxes on the main report to not be visible either.

In Access 2003, I am new to printing labels - in this case pallet labels.
We want to print them 6 up - 2 across the page, 3 top to bottom, probable
multiple pages
It seems that the label wizard is set up to print each label such that it

i have an access project to finish by tomorrow....and i am STUCK!
Please help:
i have 4 tables and i need to create a report that shows data from
each table and calculates a running tab of charges / subtotal / tax /

I am trying to convert the ClientID to client’s name.
I have;
TABLE
tbl_Client

i am using linked tables from my companies db to compilee info on a specific
project.  i import a table from Excel and run a query using one of the linked
tables.  the info that i am looking for is all there.  
when i create the report, the field (manager's name) is there but the ...

I have a report with two text boxes in Detail set to Can Grow. Both
boxes have functions as the data source. The functions simply
concatenate data from other fields in the underlying data source, which
is an Excel spreadsheet. The text boxes don't "grow" when the report is