Replies

What if I use that? I

Yes, something like that Allison.

Well, all I

Thanks Charlotte, the below worked it out.

strSQL = “SELECT NewQuery.tempYear, qryTypeMonthMgrCode.promotionType, qryTypeMonthMgrCode.Month, qryTypeMonthMgrCode.Code, qryTypeMonthMgrCode.ManagerName, qryTypeMonthMgrCode.DirectorCode, Sum(NewQuery.ActivationForecast) AS SumOfActivationForecast, Sum(NewQuery.Results) AS SumOfResults, Sum(NewQuery.TotalCommits) AS SumOfTotalCommits, Sum(NewQuery.TotalPaid) AS SumOfTotalPaid, Sum(NewQuery.Accrual) AS SumOfAccrual, Sum(NewQuery.ProjectedSpending) AS SumOfProjectedSpending FROM qryTypeMonthMgrCode LEFT JOIN NewQuery ON (qryTypeMonthMgrCode.Month = NewQuery.tempMonth) AND (qryTypeMonthMgrCode.Code = NewQuery.Code) AND (qryTypeMonthMgrCode.promotionType = NewQuery.PromotionType)” _
& ” WHERE qryTypeMonthMgrCode.DirectorCode=” & CLng(globalregioncode) & ” AND qryTypeMonthMgrCode.PromotionType='” & filterType & “‘ AND NewQuery.tempYear= ‘” & filterYear & “‘ GROUP BY NewQuery.tempYear, qryTypeMonthMgrCode.PromotionType,qryTypeMonthMgrCode.Month, qryTypeMonthMgrCode.Code, qryTypeMonthMgrCode.ManagerName, qryTypeMonthMgrCode.DirectorCode HAVING (((qryTypeMonthMgrCode.Code) 1000 And (qryTypeMonthMgrCode.Code) 1107 And (qryTypeMonthMgrCode.Code) 1108 And (qryTypeMonthMgrCode.Code) 1109 And (qryTypeMonthMgrCode.Code) 1202 And (qryTypeMonthMgrCode.Code) 1306 And (qryTypeMonthMgrCode.Code) 1307 And (qryTypeMonthMgrCode.Code) 1308 And (qryTypeMonthMgrCode.Code) 1309 And (qryTypeMonthMgrCode.Code) <= 1504)) ORDER BY qryTypeMonthMgrCode.PromotionType,qryTypeMonthMgrCode.Month, qryTypeMonthMgrCode.Code;"

Don

No change.

no answer.

(No Text)

Darn, thanks Hans.

Well point 2 is what I want & I guess what you

Yes, I understand your point, but what if the argument is not the same every time the function is called? This is what I want to do. If I specify the VALUE of the argument in the macro what good is that to me when that single value could be one of several? Hope you see my point.

Muchos gracias, excellente seniorata (THE SIMPSONS)

Hehe

Well as of my post I didn

Edited by DaveA to add URL code

this link helped me modify the regedit to include the files i wanted including zip and mdb…
See http://www.slipstick.com/outlook/esecup.htm%5B/url%5D for details.