Paramater Query

Joined
Sep 12, 2005
Messages
1
Reaction score
0
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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top