Hi, I have an unvound control which contains some text as well as the
following code:
& [Score]*100/[MaxMarks] & "
How do I restrict the calculation above to 0 places of decimal.  i tried

I have a form that serves as a printing and filtering menu. There are
numerous reports and charts that all use different filters. For a chart, I
base the chart data rowsource on a query. (e.g., Select x, y from
qryDataSource). I can edit the underlying query to get the results I ...

I'm working on an emergency call list that covers several departments for my
company.  Each department, which I've grouped, is going to have different
criteria for sorting in order to display a unique call order.  Some
departments will sort by seniority, some will sort and so I'm ...

On my report I have a field that calculates an age:
=IIf([datum1]<[Geboortedatum];Format([datum1];"yyyy")-Format([Geboortedatum];"yyyy");(Format([datum1];"yyyy")-Format([Geboortedatum];"yyyy"))-1)
This works perfect
I have this other field that should display a value depending on ...

I have a text box that calculates data from other text boxes, one of which is
from a subreport. When there are no records for the subreport the calculated
text box gives me a #ERROR. I have tried the nz function but still get the
error. I would like to trap for no records in the ...

My report of my table is ugly. I need to know how to eliminate blank lines if
no data is available for that line. No conclusions of info on other pages.
Have all conclusions of data to start all over on a new page.

I have created a database for a surplus sale.  In my report, I am trying to
include the bidder information in the group footer who has the maximum bid
for each lot.  My report is grouped by lot number.

Is there a way to make a field in a report not appear if the corresponding
value in the table is null/empty?

Please get back if need more info!

Morning all.
On my form, I have multiple check boxes for test types.  More than one check
box can be selected for each record.  On my report, I need to show a text
description for the checkboxes that are true.  I have managed to create

In Access 2003 I am using the count function in a report  in a text box
Form Footer to count the number of records displayed by a filter.
=count([VisitType]). This gives me a count of 11.
In the field VisitType I would like to just count the number of appearances

I have a report that shows just one field.  How can I set up my report to
repeat the column on page, rather than just have one column per page.  My
report right now has over 300 pages, yikes!

MS Access 2003/XP Professional/.mdb is in 2000 format.
Get the above error message when opening/previewing report that has code in
the on format event Code (code below). The error will occur with both
calculated fields and "real" fields (but other similar expressions work fine).

Hello.  Here is the code that I have to print a report in access to pdf
and I was wondering if there was a way to have it so that the filename
is automatically passed into the dialog that pops up.  That way the
only thing the user has to do is pick a location to save the file?

Hi Experts,
How should I accomplish the task to alternate/change the page header in a
report based on even or odd pages?
The result is printed through Acrobat Distiller which will then go the print