I would like to put a grey bar with a height of 6 at the bottom of each page
where it works automatically ( like a footer ).  Is there a way to do this?
Also, can you format dates in the footer like you can in a spreadsheet.  I
want for example "WEDNESDAY FEBRUARY 2, 2005".

I have created a database that tracks the daily attendace of employees.  The
information in the Table resembles something like this:
NAME               DATE             STATUS         DAY
John, Allen   3-jan-2005               P                3

I've created a have created a crosstab query using the crosstab query
wizard.  For rows I have the names of employees and for the columns I have
dates they worked.  Hours are shown for each employee under each date. I
want to change those dates to week ending dates and combine hours ...

I've created a report to print invoices on a pre-printed form; i.e., there
are printed labels specifying subtotal, tax, freight and invoice total.  
Report is grouped on OrderID (invoice number).  If customer only orders a few
items (which list in detail section of report), no ...

First of all thanks to AlCamp for providing me a solution to an earlier
problem.
I have generated a report basing on a query which gives me the
number of cases as the result. Here I'm trying to display the same on the

Since taking over an Access 2000 project a while back, this issue has been
driving me crazy.
A field  -    Net Wgt (kg)     (Yes, a very bad name for a field, could it
be the problem?)   is being used as the data source for a text box in a

OK, I have a subform that contains product information for a purchase order.  
Some orders have more than one item.  I would like to pull all items for a
single purchase order over to a report.  It is only pulling the top item now.
Please Help!

Hi, I would like to set different page margins in a report for odd and even
pages. Is this possible? Thanks.
Dorothy

I am creating a chart in a report, but when I try to edit it in design view
it shows me some other graph that Access has created with NORTH, EAST, and
WEST as the X-Axis categories and some random numbers in the Y-Axis. This
makes it difficult to actually see what I'm editing. ...

I've got a subreport that repeats itself as many times as there are records
in the subreport.  For example, if there are six records in the subreport
recordset, those six records will be displayed six times in the same
subreport.  However, the problem isn't in the underlying query, ...

I am having a problem with Access automatically inputting the freight
charge when a shipping method is chosen from a combo box. What should I
do?

Hi. I've created a report that looks a bit like an excel
spreadsheet: line after line of date, with the fields and
lines separated by a red line.
To make it easier to read across a line, I'm wondering if

I am trying to change my format of a calculated field.  I
have a field called Difference which is calculated by the
formula (2005Sales-2004Sales)/2004Sales.  2004Sales and
2005Sales have currency as the format.  I want the

I need 3 reports that look identical, but they come from different queries.
Instead of creating 3 identical reports, but with different control sources,
I would like to create the report once and then use macros, or code, from a
menu to change the control source.

I am having problem passing query params to a report that
has a chart control on it.  I am trying to pass
[forms]![MainMenu]![txtStartDate] to the chart such that
the Date field criteria is ">=[forms]![MainMenu]!