I have a report and in the report header section exists a subreport that will
print company-wide reports for a client that has multiple projects.  If I
print a report for a client that doesn't have multiple projects to report
then I have the following event placed in the On ...

Help would be appreciated for the following...
In a report, I have a field named:  CompanyName (in the DETAIL section of
the report)
I would like to be able to parse the first letter of each word.

I have a report that shows a product and below each product lists the
clients for this product.  I would like to be able to have the client
names on the one line rather than in list form.  How do I achieve
this?.

I have a subreport in my main report.  The subreport counts the records
properly, but when I insert it in the main report, it only counts 1 record.
=Sum(IIf([19a]="Always",1,0))
The report is grouped on Lname.

Hi i have a database i've created to help out some family members. they have
an old app created with lotus 1-2-3 they used in their work and i was
breaking down. so i'm trying to help out. the old app used to be a
spreadsheet and it had a bunch of reports with it. i'm trying to ...

How do you change the sort order of a report?

Hello,  I would like to add more results per page of a report. I would like
to have a minimum of 100 results per page. They are all one line entries, so
having to flip through all those pages is cumbersome. Any ideas?
Spyder

I have a query that counts the # of priorities to display them on a report.
It works great but now I ran into the problem that if there isnt a record for
a certain priority I need it to display 0 instead of not displaying anything
at all.

One of my fields has a datatype of Yes/No.  How do I show text for this and
add this text to the beginning of another text field.
For example, Captain = Yes/No and attach this to Name
On the report it should show "Captain Smith" if it is Yes and "Smith" if it

I have a report that needs to be grouped but I don't want the same data
repeated constantly.  My report shows:
Date            Order#             Items
05/01          12345               aaaaa

I have crosstab querry giving miles driven by each vehicle in each month. I
want the report to show the new months and the mileages as they are added in
table.
its like

OK.  I have a report which is sorted by week ending dates.  It works fine but
it only shows the week ending dates that have data in the query.  I need it
to show every week ending date and fill the ones with no data with zeros.  
Please help.

I have a field on a table for date of birth.  It is formatted as a long date
(displays as May 20, 1963) with the input being dd/mm/yyyy.
How do I show only the month and day on a report?

I have an Access 2000 report with several subreports which have their
own queries. All of the subreports display when I preview or print the
parent report, except one. It is set as Visible with CanShrink set to
No.  If I preview the sub report on it's own all is displayed (data is

I have read numerous posts herein and still can't seem to find what I
need...sorry if I have missed something this simple.
I would like display a total in the Report Footer from counting certain
values w/in a column.