I have three tables that I am using in a query to create my report: Personal
Data, Phone Info & Skills.  The phone info table contains multiple records
for the same vendor.  I want the phone numbers to print one right under the
other; similar to the below format.

Can anyone tell me what type of text is the same width for each character? In
my report I have quite a few labels that just won't line up because the text
is of varying number of characters Each has dots after to aid alignment i.e.
First Name ...............

Hi Group,
Access 2000, win xppro
I have never tried a subreport before although I can sort of find my way
around access and vba.

Hi. I'm using the rectangle tool to draw vertical lines, but I can't figure
out how to add to it to draw horiziontal lines as well.  I'd appreciate your
help- Thanks.

If I have the following as a fields control source in a report, is there a
way of stopping the next comma appearing if any supplying field, except the
last one, is empty?
=[AddressLine1]& ", " &[Town]& ", " &[County]& ", " &[PostCode]

I am using Access 2002 and I hoping someone can help me or point me to a
website for more information.  Here is the scoop.  I work for a reinsurance
company and I have a particular report that  the users like, but they want
the option to have the report sorted their way.  For ...

I have a report that works great when there is some information from the
query that supplies the data.  However, if there is no data available then
the form produces the #Error message is various places.  Is there a way to
prevent this something on the lines of ISError?

I have a report with one of the text boxes with the value brought in from the
report's underlying query.  2 other text boxes are using DLookUp.  I've set
each of these up with conditional formating ....
One of the DLookUp boxes is set to be red if less than zero.  It is working.

IS THERE A WAY TO BUILD A DATABASE FILE USING ACCESS. I WANT THIS FILE TO
HOLD ALL OF MY CUSTOMERS CREDIT CARD INFORMATION. I DON'T WANT IT TO RUN THE
CARD I JUST WANT A DATABASE THAT I CAN PRINT OUT SO I CAN STOP THE PAPER
TRAFFIC AND HAVE IT ALL IN THE SYSTEMS

Access 2000 SP3
Can anyone recommend a way round this odd problem.
I've got an Access report which print preview's the first page ok (it is
only 1 page long), but the next pages are blank, and its never ending, it

I a form and table I have the format set to capitalize text to speed up the
data entry time because the people putting in the data are not speedy typers.
The problem I have is when I create a report of the data it show the text as
typed, not capitalized.  Is there a way to show ...

I have an Access report the uses the below code to "gray" alternate lines of
a report. Worked fine on Access 2000 but in 2003 it doesn't work. What is
the problem.
Thanks,

I have created a report that is sorted by employee #.  How can I get the
first and last name to repeat on the next page if the data for that employee
conuinues for multiple pages.

Thanks to everyone who helped me in the queries discussions I have moved on
to my next problem. I am trying to create a report based on the query I
created. It contains up to four lines per employee by quater. I am trying to
create a one page report per employee that shows each set ...

Do SubReports on a Report have to be set to the same printer as a main
report?
Thanks
DS