This is what I do to format an amount in currency in a trim function:
=trim("The amount of " & Format([amount], "currency") & "is due on september")
Can somebody tell me if I can use the "Format" with the code to bold words
in the trim sentence above? That's it, I want to format ...

I have developed a Visual Basic program that uses the Snapshot Viewer Control
(SNAPVIEW.OCX).  The data was exported from an Access report into a .snp
file.  I have two questions:
1)  I am using the PrintSnapshot method to print the reports.  Is the some

How can I make my report print more than one record per page? Right now it
shows only one record per page on report.

I have a report of customer summary: Name, ID, and Reason, Time, and Commnet  
fields. I want to achive these data in comma separated archived file. How can
I do that?
Thank you.

I am on Day 2 with this and I am about to start banging my head on the wall.
I have tasks that have a start date and an end date.
I am trying to have a report group tasks to do during a week.
Task 1 starts in week 35, ends in week 38.

I'm getting the "you entered an expression that has no value" error
sometimes but not others, and I don't understand.
I'm trying to generate a report from a form. I'm actually using this to
generate one page at a time due to performance problems with printing

I am reporting a field in a report from a query that is sometimes blank. How
do I either get the data filled into that record or retrieve th data from
another query?  I am using this to report the dealer name in the header of
the report.  Thanks!

I'm using Access 2K and W2K. Is there a direct way to use a Combo Box in
a report?
TIA,
Carl

I have a report of students who graduate by quarter and year (for example,
03/05, 06/05, 09/05, 12/05, 03/06, 06/06, 09/06, 12/06, etc.)  It currently
is sorting by month (for example, 03/05/, 03/06, etc.)  I need it to sort by
month and year (03/05, 06/05, 09/05, 12/05, 03/06, ...

I need to create a query that will give me averages on a list of numbers.
How can I calculate the averages, but ignore 0 or null values. Addtionally
if I am ignoreing the 0 value I don't want the record field to factored in
the average count.

I am using Access 2000.
A long time ago, when I was even more of a beginner than I am now, I would
first build and save a query and then use that query as the row source for a
report.

If a crosstab report comes up with a row that does not any matching data
for that particular coloumn, you get a blank space in that area, ora zero
If you are working with a regular select query, and there is no matching
 data for that row, you don't get a row.

I would like to have in the CarName group header, a concatenated list of
people in that vehicle.  I have a query (qry_ArrivingPassengers) that
contains the LastName and CarName for all arriving vehicles.  My report
groups on the CarName.  I will need a Departing passenger string ...

I have a table that has receipt quantities for various items.  Most of the
items are entered more than once, becuase shipments are received on different
days.
How do I run a report or query that will total each individual items

I need help with adding count fields to my report.  This is the deal.  What I
have is a field that is for contracts stating if it was a win, loss, or no
bid.  I would like to add fields to my report footer that shows a count of
each (meaning wins, losses or no bids).  Is this ...