Query prompting for Parameter Value

[sergio.pringle]

How do I stop my query from asking me the parameter value everytime I
open it.

this is the query:

SELECT ESR1.[Dptr Date], ESR1.Origin_Destination, NZ(ESR1![SumOfBid
Price])+NZ(ESR2![SumOfBid Price]) AS ESR, ESR1.Class, ESR1.Value,
ESR1.Leg1, ESR2.Leg2, IIf(ESR1!Value<[ESR],"Closed","Open") AS Status
FROM ESR1 LEFT JOIN ESR2 ON (ESR1.Value = ESR2.Value) AND (ESR1.[Dptr
Date] = ESR2.[Dptr Date]) AND (ESR1.Origin_Destination =
ESR2.Origin_Destination)
GROUP BY ESR1.[Dptr Date], ESR1.Origin_Destination, NZ(ESR1![SumOfBid
Price])+NZ(ESR2![SumOfBid Price]), ESR1.Class, ESR1.Value, ESR1.Leg1,
ESR2.Leg2, IIf(ESR1!Value<[ESR],"Closed","Open")
HAVING (((ESR1.Value)<>50));

Thanks for your help.

 

[Guest]

What parameter is it asking for?

 

[sergio.pringle]

ESR

 

[Guest]

Try it this way ---
SELECT ESR1.[Dptr Date], ESR1.Origin_Destination, NZ(ESR1![SumOfBidPrice])
+NZ(ESR2![SumOfBid Price]) AS ESR, ESR1.Class, ESR1.Value, ESR1.Leg1,
ESR2.Leg2, IIf(ESR1!Value NZ(ESR1![SumOfBidPrice]) +NZ(ESR2![SumOfBid
Price]),"Closed","Open") AS Status
FROM ESR1 LEFT JOIN ESR2 ON (ESR1.Value = ESR2.Value) AND (ESR1.[Dptr Date]
= ESR2.[Dptr Date]) AND (ESR1.Origin_Destination = ESR2.Origin_Destination)
GROUP BY ESR1.[Dptr Date], ESR1.Origin_Destination, NZ(ESR1![SumOfBidPrice])
+NZ(ESR2![SumOfBid Price]), ESR1.Class, ESR1.Value, ESR1.Leg1, ESR2.Leg2,
IIf(ESR1!Value< NZ(ESR1![SumOfBidPrice])+NZ(ESR2!SumOfBidPrice]),
"Closed","Open")
HAVING (((ESR1.Value)<>50));

 

[sergio.pringle]

Thank you. That worked great.

Now, what exactly did you do, or was I doing wrong?