Is it possible to change the text color of a report field if an option button
is checked
in a form.
Form Printlabels has

I want a main report with two subreports. I get the main report to work fine,
no problem. I put in a subreport and link my master and child fields. The
problem is no matter what I do it puts the data in the subreport in between
each item in the report. In other words, I would ...

I created a report and would like to get a count of records with two
conditions.  Here is what I entered:
=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")
This information is entered in an unbound text.

I am trying to get a total of 3 different fields (1st payment, 2nd payment,
3rd payment) for all the records and display it in the report footer.
The expression I built in the footer was =Sum([1st payment]+[2nd
payment]+[3rd payment]).  This however returns with a blank.  Please ...

Hello, I am have a report that has several subreports in it..  There is a
summery section in the header section of the main report.  However if one of
the sub reports Reports #Error that will be carried through to the summery on
the main report.

I am relatively new to Access, and I want to export 1 page of my report at a
time to a .snp file.  IOW I want to be able to export page 42 of my report at
any given time.  I can't seem to figure it out.  Any help is appreciated.

Just upgraded from office XP to 2007.
When trying to edit a ms access 2000 database report including
"whereconditions", access asks for saving changes, but the report is still
open and nothing is saved. The only viable option is to exit without saving.

I have a report in which there is a text box joining two names into one
string. When the names are nothing, the text box shows #Error in the report.
How can I suppress this so that only a space, or nothing, appears in the
report.

I can't seem to determine how to create a Report that has two pages per sheet
as I can in Word.
I'm developing an Address Book to print on Daytimer Pages (2-per 8.5 x11)
and I will need to have the report set up that way.

I have a report that needs to display the total  records of current Month
(table have all year records)from Table name "Audits", the field cointaining
the date records is "Date". How can I write an expression in a textbox to
show this tota in the report?l, or how can I do this in ...

How can we concatenate 3 fields like First name and Middlem name and
LastName, so that it will not take many spaces on the report, Also I have 3
fields of address, and I want to combine address1, address2 and address3. All
are intended not taking a lot of spaces, so that we have ...

I want to design a form, every time I put the textbox for the field, it is
difficult to put it;s label as the header, Is there any easier way instead of
cut it and put it above?
Thanks in advance for any idea provided

Hi.  I have a report that shows employee data from all tables, such as
demographic info, address/location data, job information, etc.  The
report is set up to show all previous and current records for given
employee.  For example, one employee has 8 previous addresses and 5

I'm using Access 2002.
In the grouping footer I have a =sum(abs([excused]=yes)) calculation that
returns 2 yes and 1 no. (for the below sample)
Now, I want to sum the hours where [excused]=yes and then multiply it by the

I have a report which sums the sales by each customer over the current year.  
I have it layed out so that the summary is in alphabetical order by customer
name which is easy.  But I also want to have the summary in order of overall
sales...the problem is overall sales is a sum of ...