iff and data source?

  • Thread starter Thread starter Mark J Kubicki
  • Start date Start date
M

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)
 
Mark said:
- 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,"")
 
Back
Top