I am attempting to do a dlookup for a price based on the number of pages printed. I have created a report with the number of pages printed [CountPage] from a query. I also have a query that has the price matrix based on the number of pages printed. I have made a subreport based on the pricing matrix query. I then added a field in the report that contains an iif statement to look up the correct based on the subreport. The Control source has the expression =IIf([CountPage] Between [qryPricePrint_LM subreport].[Report]![ProductVolumeTierLow] And [qryPricePrint_LM subreport].[Report]![ProductVolumeTierHigh],[qryPricePrint_LM subreport].[Report]![ProductPrice]).
Problem: the price does not show up in all the rows. Currently, there are only two rows with different page counts, but only one of the rows shows a price and it is correct. The other field is blank. Please see below.
Ideas??