Re: Field Blank in Report - New Information
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Tue, 5 Sep 2006 08:25:03 -0700
One step at a time.
You used [client name], [clientname], and [clientNAME] in your description.
Spelling counts (Access is fairly stupid this way).
Please post the SQL of your query.
Does your query return the values you need/expect? Forget about the report
for a moment, just get the query working correctly.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"R Marko" <RMarko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:42DA980B-E689-4FFB-B609-9196C81C0746@xxxxxxxxxxxxxxxx
I have new information that may shine some light on this problem.
I've been testing the report and have noticed that..
a) In the form, when I create a new record and type in a [client name]
and[acronym], the [SortName] on the Report works perfectly
b) In the form, when I create a new record and insert a [clientname] and
leave the [acronym] blank, the [SortName] on the Report works perfectly
c) In the form, when the client is a repeat client and the cmb box
populates the fields including [clientname] and [acronym], the [SortName]
on
the Report works.
d) In the form, when I choose an existing client in the cmb box to
populate
the fields in the form where there is a [clientname] but the [acronym] was
BLANK, the [SortName] on the Report DOES NOT WORK. The space is blank.
The code in the query that populates the report is:
SortNAME: IIf(IsNull([ACRONYM]),[ClientNAME],[ACRONYM])
Please help me, I'm at wits end!
Rhonda
"R Marko" wrote:
I'm sorry, I just realized what you're saying.
I didn't explain myself well before. The report does get it's
information
from a query. It's in the query that I created the [SortName] field.
Rhonda
"Jeff Boyce" wrote:
Rhonda
Please re-read my response. Take your IIF() statement out of the
report and
put it in the query that returns the rows of data that feed the report.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"R Marko" <RMarko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:91386BF1-77E5-489B-9ABB-55CB003DA2EA@xxxxxxxxxxxxxxxx
It's rather a simple procedure. The original table, [tblClient]
houses
all
of the information.
[frmClient] is how we enter the information. Simple, Simple.
On occasion, clients will return with other projects. To make the
data
entry easy, I replaced the field [ClientName] with a combo box which
gets
the
information from [tblClient] and populates the address, city, state,
etc
fields, enabling us to go right to the "meat and potatoes" of the
form and
enter information about the new project.
Private Sub cmbGroupName_AfterUpdate()
Me!ACRONYM = Me![cmbGroupName].Column(2)
Me!SALUTATION = Me![cmbGroupName].Column(3)
Me!FIRSTNAME = Me![cmbGroupName].Column(4)
Me!MIDDLEINITIAL = Me![cmbGroupName].Column(5)
Me!CONTACT = Me![cmbGroupName].Column(6)
Me!NICKNAME = Me![cmbGroupName].Column(7)
Me!TITLE = Me![cmbGroupName].Column(8)
Me!ADDRESS1 = Me![cmbGroupName].Column(9)
Me!ADDRESS2 = Me![cmbGroupName].Column(10)
Me!CITY = Me![cmbGroupName].Column(11)
Me!STATE = Me![cmbGroupName].Column(12)
Me!ZIP = Me![cmbGroupName].Column(13)
Me!COUNTRY = Me![cmbGroupName].Column(14)
Me!Phone = Me![cmbGroupName].Column(15)
Me!EXT = Me![cmbGroupName].Column(16)
Me!FAX = Me![cmbGroupName].Column(17)
Me!HOMEPHONE = Me![cmbGroupName].Column(18)
Me!EMAIL = Me![cmbGroupName].Column(19)
End Sub
I created a simple report that lists all of the clients. To the
right of
the name, other information, taken from [tblClient] is listed.
Some of our clients are associations with long names, so we use
acronyms.
On the report, where I want to show the clients name, I created a
field,
[SortName] and entered...
SortNAME: IIf(IsNull([ACRONYM]),[ClientName],[ACRONYM])
When I replaced [SortName] with [ClientName] it works fine.
What is wrong with my "If" statement?
Hope this explains it.
Thank you,
Rhonda
"Jeff Boyce" wrote:
Rhonda
I'm having trouble visualizing your underlying data structure. You
described combo boxes, reports, ..., but I don't see where the
original
table data is coming from, nor do I see the query that you are using
to
"feed" the report(s).
If you put that same IIF() function into a query against your
underlying
table(s), you might be able to use that without issue in your report
definition.
Regards
Jeff Boyce
Microsoft Office/Access MVP
"R Marko" <RMarko@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F0EDC68B-9232-434E-B058-54A44B2A1207@xxxxxxxxxxxxxxxx
I've recently added a combo box which pulls information from our
client
list
in order to populate the Address, City, State, Zip, Phone, Fax in
the
new
record. Works great.
In the report, all of the information prints. Life is Good.
In an effort to save space (and paper) on several reports I
created a
"SortNAME" field
SortNAME: IIf(IsNull([ACRONYM]),[ClientName],[ACRONYM])
so the acronym prints instead of the long name.
My problem.....In those records where the drop down, combo box was
used
to
populate the client name, the client name does not print when I
request
the
"SortNAME"
If I insert the field "ClientName" on the report, it prints.
If I use the field "SortNAME" on the report, it's blank (only in
the
records that were populated by the combo box)
Any ideas???
Rhonda
.
- References:
- Re: Field Blank in Report
- From: Jeff Boyce
- Re: Field Blank in Report
- From: R Marko
- Re: Field Blank in Report
- From: Jeff Boyce
- Re: Field Blank in Report
- From: R Marko
- Re: Field Blank in Report - New Information
- From: R Marko
- Re: Field Blank in Report
- Prev by Date: Re: cross-table or something alike
- Next by Date: Re: Specity fixed criteria in a reportheader
- Previous by thread: Re: Field Blank in Report - New Information
- Next by thread: Number of hours in report
- Index(es):
Relevant Pages
|
Loading
