[mso] Re: Access 2003: How to Conditionally Print A LIne In AReport?

Ray,

If when you created the report you used the wizard and selected a table
to report on, youdo not need to qualify the field names with teh table
name.  It will confuse the report and it will interpret the table name
[PEOPLE] with a parameter field and request it.  It will then nat be
able to resolve the field names and you will get the error.  Here is a
sample control source I used that shows how complicated cancatenation
can get:  =3DTrim([chrLastName] & ", " & [chrfirstname] & " " &
[chrmidinit]).  Try removing the [people! from your data source string.=20


Robert Tillotson
BAE-IT
Groton Field Office
860-441-2207

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Ray Shapp
Sent: Thursday, December 13, 2007 12:38 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access 2003: How to Conditionally Print A LIne In
AReport?

Hello David and Robert,

Thank you for continuing to work with me.

<<Easiest first:  bound simply means the text box is getting its
contents from a field in the record being printed.>>

I understand.


<<As for the boxes overlapping:...>>

In my test report, I have only one line in the detail portion of the
report.=20
There is nothing to overlap

I am attempting to follow Robert's suggestion of combining both of your
ideas.=20
Now the only field in the detail section of my test report is the
following
expression:

   =3DTrim([PEOPLE]![PHONE] & [PEOPLE]![2nd_Phone])

When I run the test report, a small window named "Enter Parameter Value"

opens, and "PEOPLE" is shown above the input window. It doesn't matter
whether I enter nothing or such values as "all" in the input window. The
result is a 55-page report that contains only "#Error" on every other
line. The alternate lines are blank.

As an experiment testing the concept of concatenation, I replaced the
expression above with the following:

 =3DTrim("A"&"B")

This also gave me a 55-page report. It alternates lines containing "AB"
and blank lines.

Please tell me what's wrong with the expression:

   =3DTrim([PEOPLE]![PHONE] & [PEOPLE]![2nd_Phone])

Please also tell me what parameter value is being requested.

Thanks again.

Ray Shapp


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister
group.  This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: