If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error on field
I have this statement on a field in a report.
=IIf((IsNull([ALUMNI_Minor])),[ALUMNI_Major],[ALUMNI_Major] & "/" & [ALUMNI_Minor]) If the person doesn't have a minor then just list the major, if they do have a minor then insert a / inbetween the two. I get #Error. The name of the filed that this expressision resides is "txtMajorMinor", I've also checked and I do have ALUMNI_Major and ALUMNI_Minor in the query for the report. Anyone... Merci |
#2
|
|||
|
|||
In reports, if you want to use a field in an expression like this, you also
need to put a control (bound to the desired field) in the same section as the control that is using this expression. To not have this other control be visible, set its Visible property to No in design view. -- Ken Snell MS ACCESS MVP "Andy G" wrote in message ... I have this statement on a field in a report. =IIf((IsNull([ALUMNI_Minor])),[ALUMNI_Major],[ALUMNI_Major] & "/" & [ALUMNI_Minor]) If the person doesn't have a minor then just list the major, if they do have a minor then insert a / inbetween the two. I get #Error. The name of the filed that this expressision resides is "txtMajorMinor", I've also checked and I do have ALUMNI_Major and ALUMNI_Minor in the query for the report. Anyone... Merci |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 - Many to Many Relationships | Lynn | General Discussion | 5 | July 8th, 2004 12:55 AM |
How to define a field to aid searching | Bam Bam | General Discussion | 3 | July 7th, 2004 07:05 PM |
Supress blank lines in DOCPROPERTY field | Mary | Formatting Long Documents | 10 | May 25th, 2004 07:27 PM |
Create table with field names based on the value of a field in another table. | [email protected] | Database Design | 5 | May 24th, 2004 02:32 PM |
Pivot Table - Format of Date Field | Michelle | Worksheet Functions | 1 | February 3rd, 2004 07:56 PM |