Is there a way to control the dollar sign on a currency field on a
report so that the dollar sign only appears on the first item in the list?
Also, how can I format the dollar sign so that there is a space between
the dollar sign and the number (like the accounting format in ...

I have been using the Abs(Sum) function in a report to count particular
values from specific fields.  I have also used it to count Yes values in
two separate checkbox fields to produce one total.  Example:=((Abs(Sum(
[Ad_sur_sa]=Yes)))+(Abs(Sum([Ch_sur_sa]=Yes))))  That example ...

Hi. I want to run a report that shows all birthdays in a
month by letting the user select the month.
I think I did things the ineffecient way- by setting up a
table listing the 12 months, and then creating an unbound

ACCESS 2000
I have a report that when opened you are promted to enter a START DATE and
an END DATE, and the output shows those employees whose recertification
expires within that date range.

i have a table containing start & stop times (by date) for a production
processing plant -
Date.......Start..........Stop.......Reason
1/1/05...8:00am.......10:00am...Smoko

Can it be done?
I need to create a report to print twice a record on 1 A4 page.
Is this clear or do I have to explain more?

when creating a report, data in some fields may not be available. how do I
make the field headings (captions) disappear (hide) when there is no data for
a field?

I have a an unbound field in a report that utilizes the switch function.  The
field is based on date entries in the report.  I have been unable to set the
field to output the word "Unknown" if the date entry "is null"
here is the line I have in control source, how do I include the ...

I need to define and declare parameters and varaibles inside the report and
not inside the query. Where Should I Do So? and How.
For example I need to state thatL If [text1]=1 then X=2
where in used in the report and should not be asked for.

I wish to print a text box as the page header on every
page after page 2
how do i do this please

I have a report with an image.  The image displays nicely in print preview,
but does not show up when I print hardcopy.  

I am trying to build a report for our advisors.  In the report each
advisor's total number of students shows for each month.
December 2005
                                                          Adv  Total

In a report, in a header, I want an unbound text box to change a number into
the name of the month. I have written the statement =IIf([Month]=1,"January")
and get the return January. But I cannot expand the statement to contain the
other 11 months. All I get are the usual error ...

I am making a payroll report, my problem is the default start of week is Sum.
Payroll starts on Mon., so if an employee works on Sun. it will be grouped
with this weeks time and not last week.
Can I change Access to reconize Mon. as the first day of week?