I have set up a field that calculates the average of the data from the field called "Result", which is named as "AveOfResult" in the SQL view. I try to use this field for another calculation, Access somehow recognizes this new field, "AveOfResult" as a paramater and gives me a paramater window when I switch to a datasheet view...
Could anyone tell me how to set up so that I don't see a paramater window?
Thanks in advance!
-------------------------------------------------------------------------
SQL:
SELECT [RAW DATA].[Item#], [RAW DATA].Spike, Avg([RAW DATA].Result) AS AvgOfResult, [AvgOfResult]/[Spike] AS Difference
FROM [RAW DATA]
GROUP BY [RAW DATA].[Item#], [RAW DATA].Spike, [AvgOfResult]/[Spike]
ORDER BY [RAW DATA].Spike;
Could anyone tell me how to set up so that I don't see a paramater window?
Thanks in advance!
-------------------------------------------------------------------------
SQL:
SELECT [RAW DATA].[Item#], [RAW DATA].Spike, Avg([RAW DATA].Result) AS AvgOfResult, [AvgOfResult]/[Spike] AS Difference
FROM [RAW DATA]
GROUP BY [RAW DATA].[Item#], [RAW DATA].Spike, [AvgOfResult]/[Spike]
ORDER BY [RAW DATA].Spike;