another "Enter Parameter Value" msg box question

[arpeggione]

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

 

[ZmrAbdulla]

I think the red letters part must be like
qryBreakerSubEventsCustMins.SubEventCustMins

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

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[arpeggione]

Thank you Zameer for your reply...I appreciate it. I tried changing the "!" to a ".", but am still getting the same "Enter Parameter Value" msg box. Any other ideas?

thanks again,

Karen

 

[arpeggione]

Please note: I accidentally posted this in the "Access Forms forum" and meant to post it in the "Queries" forum, so...I've copied it over to the "Queries" forum...

thank you,

Arpeggione

 

[ZmrAbdulla]

What I meant to say that the QueryNames are different. Make sure it is correct

qryBreakerSubEventsCustMins.SubEventCustMins
qryBreakerSubEvents!SubEventCustMins

________________________________________________________
Zameer Abdulla
Help to find Missing people