Can you tell me what this says?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Typecode IIf:([primary data tabe]![rel]is null, [primary data
table]![typecode], [primary data table]![rel])

Just what is being asked here? I am new at wildcards...

Thanks,
hk
 
There are no wildcards there, but there are some errors (maybe just typing
mistakes).

If you'd put this

Typecode: IIf([primary data table].[rel] Is Null, [primary data
table].[typecode], [primary data table].[rel])

it would specify a calculated field (in Access's query design grid) called
Typecode. If the first term of the IIf() function
[primary data table].[rel] Is Null
is true (i.e. the field "rel" in that table has the special value Null), the
IIf() returns the value of its second term, namely
[primary data table].[typecode]
i.e. the value of the "typecode" field. Otherwise it returns the value of
the third term, i.e. the value of "rel".

I hope that helps.


, whose value is:
If the field "rel" in the table "primary data table" is null, the value of
the field "typecode";
If [primary data table].[rel] is not null, the value of
 
Thank you, you answered my question. I knew that the first part was the
question and the others the answers, but just how. IIF()= meaning to return
the value in question, so if the 'rel' value is null, then the 'typecode'
value is returned or if there is a 'rel' value than that value is returned.
I am working with a campus database, where a value in 'typecode' will
sometimes require a value in 'rel' and I was trying to understand the
expression that the previous database user had created in a query using that
expression. I started reading the Access 2002 Bible and found that very
helpful, and your help is great, this group will hear more from me. A
million thanks.

John Nurick said:
There are no wildcards there, but there are some errors (maybe just typing
mistakes).

If you'd put this

Typecode: IIf([primary data table].[rel] Is Null, [primary data
table].[typecode], [primary data table].[rel])

it would specify a calculated field (in Access's query design grid) called
Typecode. If the first term of the IIf() function
[primary data table].[rel] Is Null
is true (i.e. the field "rel" in that table has the special value Null), the
IIf() returns the value of its second term, namely
[primary data table].[typecode]
i.e. the value of the "typecode" field. Otherwise it returns the value of
the third term, i.e. the value of "rel".

I hope that helps.


, whose value is:
If the field "rel" in the table "primary data table" is null, the value of
the field "typecode";
If [primary data table].[rel] is not null, the value of


hellokitty11 said:
Typecode IIf:([primary data tabe]![rel]is null, [primary data
table]![typecode], [primary data table]![rel])

Just what is being asked here? I am new at wildcards...

Thanks,
hk
Click to expand...
Click to expand...
 
Back
Top