another "Enter Parameter Value" msg Box question

[arpeggione]

Please note: I accidentally posted this in the Access Forms forum instead of the Queries forum, so am reposting....

I have a query for Total Customer Minutes that combines Event Cust Minutes and SubEvent Customer Minutes. Every time I run the "Total" query, I get the "Enter Parameter Value" message box for qryBreakerSubEvents!SubEventsCustMins. I've been reading through other postings about similar problems, but still haven't seen the light. Any help would be appreciated!

Below is the SQL code (taken from the QBE SQL screen):

SELECT DISTINCTROW Sum(qryBreakerEventsCustMins.EventCustMins) AS SumOfEventCustMins, Sum(qryBreakerSubEventsCustMins.SubEventCustMins) AS SumOfSubEventCustMins, Sum(qryBreakerEventsCustMins!EventCustMins+qryBreakerSubEvents!SubEventCustMins) AS TotalCustMins
FROM qryBreakerSubEventsCustMins RIGHT JOIN qryBreakerEventsCustMins ON qryBreakerSubEventsCustMins.[Parent Event Link] = qryBreakerEventsCustMins.[System Events Counter];

thank you kindly,

Arpeggione

 

[PHV]

I'd replace any bang (!) with dot (.)
Does qryBreakerSubEvents really have a field named SubEventsCustMins ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[arpeggione]

Thanks for your msg...I tried this and am still getting the "Parameter Value" msg box. Please note that SubEventCustMins used to be called Cust_Mins. I've read that changing the name of a field could cause this problem.

Any other ideas?

thx,

Karen

 

[traingamer]

Since your error message is qryBreakerSubEvents!SubEventsCustMins and qryBreakerSubEvents is not referenced in the query given, it is apparently a subquery to one of the referenced queries.

If you look at that query, is there a column named SubEventsCustMins? And will that query run on its own? (This is really the same question PHV is asking).

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[PHV]

Replace this:
Sum(qryBreakerEventsCustMins!EventCustMins+qryBreakerSubEvents!SubEventCustMins)
with this:
Sum(qryBreakerEventsCustMins.EventCustMins+qryBreakerSubEventsCustMins.SubEventCustMins)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[traingamer]

Please ignore my earlier comment. Need my eyes checked or something...

 

[arpeggione]

To PHV and Traingamer: Well, PHV's last suggestion was it...I am embarrassed to say, I had the subquery incorrectly named in the last query....that did it!

thank you both for your time and help!

karen

 

[ZmrAbdulla]

This is what I was telling you in the other thread.

http://www.tek-tips.com/viewthread.cfm?qid=1499445&page=1

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[arpeggione]

Zameer: You are absolutely right and I missed it (only noticed the . vs !....a bop on the head for me....

thank you for your help...

karen