S
SueOT
I have created an access report based on a crosstab query.
The crosstab query has a parameter in it to select data
from a specific week no. I spcified the parameter in the
Query - Parameters dialog box. Ther query runs and asks
for the parameter correctly.
The report however asks twice for the parameter and then
gives me the message "The Microsoft Jet database engine
does
not recognise the [Week No] as a valid field name or
expression (error3070).
SQL view of Query -
PARAMETERS [Week No] Long;
TRANSFORM Sum([Daily Sales Query].[Sales Quantity]) AS
[SumOfSales Quantity]
SELECT [Daily Sales Query].Date, [Daily Sales Query].
[Week No], [Daily Sales Query].Site, Sum([Daily Sales
Query].[Sales Quantity]) AS [Total Of Sales Quantity]
FROM [Daily Sales Query]
WHERE ((([Daily Sales Query].[Week No])=[week No]))
GROUP BY [Daily Sales Query].Date, [Daily Sales Query].
[Week No], [Daily Sales Query].Site
PIVOT [Daily Sales Query].[Sales Type];
Grateful of any advice offered.
The crosstab query has a parameter in it to select data
from a specific week no. I spcified the parameter in the
Query - Parameters dialog box. Ther query runs and asks
for the parameter correctly.
The report however asks twice for the parameter and then
gives me the message "The Microsoft Jet database engine
does
not recognise the [Week No] as a valid field name or
expression (error3070).
SQL view of Query -
PARAMETERS [Week No] Long;
TRANSFORM Sum([Daily Sales Query].[Sales Quantity]) AS
[SumOfSales Quantity]
SELECT [Daily Sales Query].Date, [Daily Sales Query].
[Week No], [Daily Sales Query].Site, Sum([Daily Sales
Query].[Sales Quantity]) AS [Total Of Sales Quantity]
FROM [Daily Sales Query]
WHERE ((([Daily Sales Query].[Week No])=[week No]))
GROUP BY [Daily Sales Query].Date, [Daily Sales Query].
[Week No], [Daily Sales Query].Site
PIVOT [Daily Sales Query].[Sales Type];
Grateful of any advice offered.