iff and data source?

[Mark J Kubicki]

- tblFixtureData is a table which contains multiple records, and is
designated as the data source for my report;
- tblFixtureSchedulePrintOptions is table which contains "print options",
and is designed to determine what information is included in the report (it
contains only 1 record)...

ex: if in tblFixtureSchedulePrintOptions the field InclLocations is TRUE,
then print the Locations which are included in tblFixtureData

however, this code (which, of course, I thought would be correct) is not;
any suggestions on what I am missing would be greatly appreciated:

=[FullDescription] &
iff(tblFixtureSchedulePrintOptions!InclLocations,"Location:"+[Location],"")

thanks in advance,
mark (newbie)

 

[Marshall Barton]

- tblFixtureData is a table which contains multiple records, and is
designated as the data source for my report;
- tblFixtureSchedulePrintOptions is table which contains "print options",
and is designed to determine what information is included in the report (it
contains only 1 record)...

ex: if in tblFixtureSchedulePrintOptions the field InclLocations is TRUE,
then print the Locations which are included in tblFixtureData

however, this code (which, of course, I thought would be correct) is not;
any suggestions on what I am missing would be greatly appreciated:

=[FullDescription] &
iff(tblFixtureSchedulePrintOptions!InclLocations,"Location:"+[Location],"")

You need to retrieve the print option thingie from the
table. Something like this might be what you want:

=[FullDescription] & iff(DLookup("InclLocations",
"tblFixtureSchedulePrintOptions"), "Location: " &
Location,"")