I can't make any suggestions about your example without seeing the underlying data/form/report
You could have a look at another example - my Currency Exchange Rate Tracker http://www.mendipdatasystems.co.uk/cert/4594365453
The free version is an ACCDE file
Select the currencies you want to show and download some data for a few days.
The data report will look something like this (also available on a subform)
The crosstab query SQL used for that report is:
Code:
TRANSFORM First(qryExchangeRates.Rate) AS FirstOfRateSELECT qryExchangeRates.Use, qryExchangeRates.Base, qryExchangeRates.CurrencyCode, qryExchangeRates.Currency
FROM qryExchangeRates
WHERE (((qryExchangeRates.Base)=GetBaseCode()))
GROUP BY qryExchangeRates.Use, qryExchangeRates.Base, qryExchangeRates.CurrencyCode, qryExchangeRates.Currency
ORDER BY qryExchangeRates.CurrencyCode, qryExchangeRates.Date
PIVOT qryExchangeRates.Date;
In this example, due to space limitations, only the last 20 records are selected in each case.
The same query is also used as the basis for charting exchange rate data - also available on a subform & a report
This time here is the subform to show how the currencies selected can be dynamically changed
All filtering is done on the forms - no PARAMETERS specified anywhere in the crosstab or any of the queries used to build that