I need to shade specific lines in the detail.
For Example:  A report with names and ages:
Name:           Age:
Joe                 21

I don't see the MOD function in Access, like I have available in Excel, to
determine a remainder when converting days to weeks.  I want to round "up" to
the next higher week, for any fraction of a week above even weeks.

Hi. I have a report to track how many hours our volunteers
give a year.  I've used DateDiff to calculate the Shift
hours per Volunteer.  But I can't figure out how to
multiply that by the frequency.  For example, if I have a

I have a need to print a report containing many, many records called "Job
Steps". These records are grouped by a field called "JSA Record Number"
The problem I have is that I want to print all the records for a given "JSA
Record Number" on one page. I've set the sorting and ...

I am using Access 2000, and am trying to set the .visible property of a label
on a report from the code. Is this possible? If so, does anyone have an
example?
Thanks.

I created a database for my church to handle membership and collections.  
They would now like to add pictures for a printed directory.  I'm by no means
an expert, so please bear with me...
I've added a text field 'fld_picture' to the membership table and there I

I need to know the Max amount of entries I can put in one table, so I can
make the right number of table to enter information to access that table
number.
Thank you for your help?

In parameter queries, is it possible to search for null values?  If so, how?
Thanks,
Jim

I've created a query from two tables.  The first is a "master table" of data
elements with an associated "common name" for each element (i.e SSN is the
common name used for all fields that define a social security number - SSN,
SOC-NBR, etc.) as well as other descriptive ...

I've a dataset with the following fields:
-Date (date-field)
-O (long)
-H (long)

lost connection...sorry if this appears twice.
I created a database for my church to manage membership & collections.  They
would now like to add pictures to have a printed directory.  I'm someone of a
novice, so bear with me.

I want to have a rectangle with rounded corners as a frame around some of
the controls in my report. Does anyone know if there is an easy way to do
this, or do I have to draw it in mspaint or simular and then insert it as a
picture file in my report.

I have a report based on a cross tab query that up until yesterday was
working fine.  Now when I run the report one of the text boxes does not show
the required text, it only shows a Square, 1 Square for each line of text.  I
checked the cross tab query and the cross tab query ...

I have finally figured out how to create a crosstab query based on user input
from a form.  However, now I am having trouble creating the report.
Ideally, I would like to have the user select the PRODUCTS he/she would like
to view the measures for and then be able to click an ...

i m designing report with fields name, addressline1,addressline2,
suburb,state..
i want output sth like this
Mr. peter                addressline1