criteria question

[Angi]

I'm trying to get a total for 2 months but i'm either only getting one or a 0.
I've been at this all night and can't figure it out. Any help would be greatly
appreciated!

TIA

my sql code: (returns the aug04 number) Tried AND instead of OR and got the 0.

UPDATE [Z_Monthly PRVU Report], CCH_PRO_RVU_FY05 SET [Z_Monthly PRVU
Report].MonthTotalFY05 =
(CCH_PRO_RVU_FY05!CCH_IN_CT)+(CCH_PRO_RVU_FY05!CCH_IN_FLUORO)+(CCH_PRO_RVU
_FY05!CCH_IN_MAMMO)+(CCH_PRO_RVU_FY05!CCH_IN_MRI)
WHERE ((([Z_Monthly PRVU Report].Place)='cch_in') AND
((CCH_PRO_RVU_FY05.MONTH)="JUL04")) OR ((([Z_Monthly PRVU
Report].Place)='cch_in') AND ((CCH_PRO_RVU_FY05.MONTH)="AUG04"));

 

[Michel Walsh]

Hi,


if there is no typo, something like:


UPDATE [Z_Monthly PRVU Report]

SET MonthTotalFY05 =

DSUM("CCH_IN_CT+CCH_IN_FLUORO
+CCH_IN_MAMMO+CCH_IN_MRI",

"CCH_PRO_RVU_FY05" ,

"[MONTH]=IN('JUL04', 'AUG04') " )

WHERE [Z_Monthly PRVU Report].Place='cch_in'




Hoping it may help,
Vanderghast, Access MVP