Hello,
I am using IIF to pull specific records onto a report. My data is setup so that when the header record is made, I can add specific detail records for that header. The PK of the Header table and the FK of the detail table are always the same. I have written a query to pull all of the records together to show a summary on a report. Here is the IIF statement that I have written to pull the specific data out and it is not working.
=IIf([qry_DataCollectionForReport!DBH]=16,IIf([qry_DataCollectionForReport!Stage]=6,[qry_DataCollectionForReport!Trees],0),0)
DBH, Stage and Trees are all detail records that are pulled by the query based on date.
I can send/post my database if needed.
Any help would be greatly appreciated.
Thank you,
Liz
I am using IIF to pull specific records onto a report. My data is setup so that when the header record is made, I can add specific detail records for that header. The PK of the Header table and the FK of the detail table are always the same. I have written a query to pull all of the records together to show a summary on a report. Here is the IIF statement that I have written to pull the specific data out and it is not working.
=IIf([qry_DataCollectionForReport!DBH]=16,IIf([qry_DataCollectionForReport!Stage]=6,[qry_DataCollectionForReport!Trees],0),0)
DBH, Stage and Trees are all detail records that are pulled by the query based on date.
I can send/post my database if needed.
Any help would be greatly appreciated.
Thank you,
Liz