Sorry for the trouble.

PostPeriod NPI location ...

I fixed everything...................

--===== If the test table already exists, drop it

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE...

Also, the MTD and YTD should be the same value for 11010.

Please use the code in the previous post for the data. I made a mistake by not following the...

Nope. There is a record in PostPeriod 11102 with the code 096374.

This code is not in 11103 so, it is not calculating the YTD correctly.

S_PostPdS_ProvNPIS_Locationlocation_mappinglocation_categorycategoryS_CPTS_ModifierS_Charge_AmtS_Units

111021679552582DOCTORS OFFICE-LIBERTY STREETDOCTORS OFFICENON LABADMIN/INJ096374...

Jeff,

Pardon my ignorance. I should have read your post regarding forum etiquette first.

I hope I did this correctly.........here is three months of data for one provider. From here I...

I've attached an ACCESS db with some data. The post periods run from 11010 (October, 2011) thru 11106 (June, 2011). This data is for one provider but, many locations, categories,...

To be a little more clear, I'm trying to get MTD and YTD totals for the category, ADM/INJ. If you do the math "off line" it doesn't add up correctly.

Not sure if this helps. The last two fields are MTD and YTD

110101679552582KELLEY-HEDGEPETH M.D.,ALYSONDOCTORS OFFICE-LIBERTY STREETDOCTORS OFFICENON LABADMIN/INJ096365n/a13.0013.00

110101679552582KELLEY-HEDGEPETH M.D.,ALYSONDOCTORS OFFICE-LIBERTY STREETDOCTORS OFFICENON LABADMIN/INJ096374n/a5.005.00

110111679552582KELLEY-HEDGEPETH M.D.,ALYSONDOCTORS OFFICE-LIBERTY STREETDOCTORS OFFICENON LABADMIN/INJ096365n/a16.0029.00

110111679552582KELLEY-HEDGEPETH M.D.,ALYSONDOCTORS OFFICE-LIBERTY...

For example ........ if in January there is cpt code 93762 with 10 units, February there are 5 units, in March there are no units, so there is no record...