I have a crosstab query that takes the start and end date parameters from a form. This form is used in several other queries [which work perfectly] but the one below prompts the user for the date range seven times. The parameter definitions are the same in each query. The one difference between this and my other queries is that this is grouping by month, while others are grouping on different fields. Any idea why there are several prompts for the date range?
Thanks
Code:
PARAMETERS [Forms]![Date_Range]![Start_Date] DateTime, [Forms]![Date_Range]![End_Date] DateTime;TRANSFORM Round(Sum([Total_Net]),2) AS Expr2
SELECT [All_Invoices_18-19].Supplier, Sum([All_Invoices_18-19].Total_Net) AS [Total Of Total_Net]
FROM [All_Invoices_18-19]
WHERE (((Format([Invoice_Date],"yyyy/mm")) Between [Forms].[Date_Range].[Start_Date] And [Forms].[Date_Range].[End_Date]))
GROUP BY [All_Invoices_18-19].Supplier
PIVOT Format([Invoice_Date],"yyyy/mm");