Good afternoon,
I am struggling with this one... I am trying to create a query to support a subreport and am drawing a complete blank. All of the data is contained in one table called "CheatSheet"... The table contains purchasing quotes for supplies. We have created a report whereby the main report shows one quote and we want to compare it to all of the other quotes in the table in a subreport. If the price of all of the other quotes is higher than the quote on the main report, we want the subreport to return no records or null and then I can essentially hide the subreport. If however, there is one quote lower than the quote on the main report, then we want to see all quotes returned.
Our current SQL statement for the subreport looks like this:
Any direction you can provide would be appreciated. Thank you.
I am struggling with this one... I am trying to create a query to support a subreport and am drawing a complete blank. All of the data is contained in one table called "CheatSheet"... The table contains purchasing quotes for supplies. We have created a report whereby the main report shows one quote and we want to compare it to all of the other quotes in the table in a subreport. If the price of all of the other quotes is higher than the quote on the main report, we want the subreport to return no records or null and then I can essentially hide the subreport. If however, there is one quote lower than the quote on the main report, then we want to see all quotes returned.
Our current SQL statement for the subreport looks like this:
Code:
SELECT [CheatSheet].[QuoteID],[CheatSheet].[Vendor],[CheatSheet].[Price],[CheatSheet].[QuoteSubmissionDate],[CheatSheet].[Currency]
FROM [CheatSheet]
HAVING (([CheatSheet].[QuoteID])<>[Forms]![frmRFQ!][QuoteNumber])
ORDER BY [CheatSheet].[QuoteSubmissionDate] DESC;