I'm using the inventory database that came with Access 2003.  I created a
report that requires UnitsOnHand be printed.  I've tried everything in the
book and I can't get it to work.  In the Products Form - Where the
UnitsOnHand is displayed works fine, but when I try to use the ...

How can I put invoice numbers that automatically change on a report?  I need
to do this because, I invoice customers monthy, for a group of orders created
during the month for thaat one customer, but don't send their invoice until
the end of that month, so the invoice created is ...

I'm working on a report to show up to 6 people's statistics, and use their
names as column headers. The names I get from a select query  identyfying
them with criteria.
The report I'd like to look as follows..

How can I print a report to a file using a filename based on one field of
data in that report.  I print shippers then send an electronic copy to
corporate based on the shipper number used in the report.

I currently hold sales data which is grouped by WeekNumber as follows;
WeekNumber, OrderDate, Rep, ContractValue
WeekNumber is in text format and OrderDate is in Short Date format. I have
been asked to produce a report that shows the sales for each Rep with the

Hi
I have the following formula, which works when all fields for a date range
are filled in.  However, if there were no calls of a particular type for the
period, ACCESS returns a blank.  How do I get ACCESS to 'recognise' the NULL

I recently installed A2003 and label reports which have been working for
years stopped working.  I have been using the same printer for 4 years so it
is not a printer problem.  I use the standard avery labels that print 3x10.  
They were set up with a .5 top margin, 1" for each ...

I have created a database for my business. It has several tables including
Order history, Order Details, Suppliers, Customer Info.
All orders are tracked by an order number. This is the field used in the
relationships. It is a key unique field.

how should I resolve the problem of outputing a single page report.
I have an Inoice report with all informations and  sub_report on it with
items informations.
I was based on Northwind database to create most of parts of my database.

I have a database that has fields ED1 and ED2.  My report shows the result of
either ED1 or ED2, depending if ED2 is null or not.  My problem is that
everything is fine if all are ED1 but once there is also an ED2 entry it
shows sorting as just ED1.

Can anyone tell me how to add together two values from two subreports.
I have a Monthyl Report system within which there are two subreports - one
lists CashSales the other lists Invoices.
At the bottom of each subreport there is a total of sales value.

Does anyone have an example or pointers to an access "Flexible Reporting"
capability or feature.  WHat I mean is ... I would like to offer the user the
ability to select certain fields in the DB and then push a button to create
the custom report.

I have a line on a report which includes a concatenated field ie ="the cost
for you will be " & [charge] & " plus tax"
The [charge] field is a somewhat complicated iif statement which I have
calculated in another, non visible, control on the form (although I don't

I have this problem where the date fields are in text format, and I'm trying
to count the number of a person's work days.
Date             Current Output Count               Required Output Count
4/1/2005

I have a database in Access for people's names and phone numbers just like a
phone book.  I am attempting to create a report to print that includes the
person's last name, trimmed, plus their first name.  Then I would like a dot
leader with their phone number right justified.