I have a report in which I want to calculate the average length of time from
"PointA" to "PointB". Not all records HAVE a "PointB". Can I exclued those so
that I'm only averaging the folks who got to "PointB"?

We have a multi user database. We are using Access 2003 and XP.  
The users that are using laptops with Access loaded are having problems when
previewing reports.  
The reports are set as landscape in the page setup.  The first time the

I've been banging my head with this problem all day.  I've got a report
in Access 97 that needs to be exported to an RTF file.  This Access
report has a field in the Report Header with a value of =date().  When
I export it to an RTF, the date shows on the report as it should when

I want to programatically change the Picture property associated with an
Image object on a report at runtime... how and where would you do it ?
Tried On Format...
Me.imageName.Picture ="C:\image1.bmp"

I need to do a calculation with a Dsum function in the detail section of a
report.  I actually need to use the Dsum function twice.  One Dsum will
calculate a total based on another field's value in the report, but the other
Dsum will generate a number that will be static, or ...

We produce a variety of reports for clients which contain SSN's.  I need to
be able to display only part of the SSN field on reports.

How do I put a vertical line down the middle of the detail section of a two-column report?
I know that I can put a line at the right end of the column 1, but it will repeat at the right end of column 2,
and I don't want that. Same principle applies to putting a line at the left end ...

When report was built, I set margins at .25 and landscape.  Sometimes when I
run report it is correct, sometimes it is portrait with 1" margins.  Why does
this happen?  Using Access 2000 with Windows XP

I have a report with a "subreport", they both run off of separate queries
(Exchange_Query & Total_Query).  Both queries need dates entered (start date
and end date on both).  When I run the report that includes both queries
Access asks for the date frame 3 times to view and 3 ...

I need the gourp headings in my report to go accros the hole page where the
other record are show in columns.  The group headder wants to cut off at the
end of the first column.  Can some one pleae help? Thanks
Here is an Examnple:

Hello Everyone, I am opening and modifying an MDB made with Access2000 in
Access2003.
I noticed that the TRIM function is giving trouble, because it seems to be
not accepted as it used to be in older versions of Access.

I need help, I don't don't how to create reports in Access 2003 yet, and I
need to import previously prepared reports however the previously prepared
reports were prepared in MSWorks 4.0.  The reports are saved in *.wps format,
however they are linked to a *.wbd file.  Any ...

I have a text field that has the form input format of 99/99/00;0;_  I would
like to format the field on the report to show only the year.  Also can it be
formated with all 4 digits?
thx

I want my records grouped by a field but I want to sort them in the order I
want, not ascending or descending. It seems I'm stuck with just the two
choices.

After createing a report looks like the defalt margins in the page setup is
Top = 1", Bottom = 1", Left = 2.5", and Right = 1"
I need to change page layout to landscape. Now the Left margin is 2.5" and I
can't seem to change it. Help!