warriorwoman
New Member
- Joined
- Mar 18, 2010
- Messages
- 22
I get medical reports through each month and some are in YTD format when I actually need to report the given months data.
I need to find a way to subtract the M4 YTD report from the M5 YTD report to reveal the M5 in month movement and so on.
I'm looking for ideas on how to achieve this.
I have a single table for each month and each table is in the same format:
MONTH
HOSPITAL
COMMISSIONER
TREATMENT TYPE
RESOURCE GROUP
SPECIALTY
YTD PRICE PLAN
YTD PRICE
YTD ACTIVITY PLAN
YTD ACTIVITY
Each month will have different numbers of rows (approx 20,000) but it is probably safe to assume that the last month will have all the data rows in.
I would like an output in exactly the same format only with the YTD fields replaced by in-month equivalents.
Have I given you enough information to give me a tip on how to construct my query?
Thanks
I need to find a way to subtract the M4 YTD report from the M5 YTD report to reveal the M5 in month movement and so on.
I'm looking for ideas on how to achieve this.
I have a single table for each month and each table is in the same format:
MONTH
HOSPITAL
COMMISSIONER
TREATMENT TYPE
RESOURCE GROUP
SPECIALTY
YTD PRICE PLAN
YTD PRICE
YTD ACTIVITY PLAN
YTD ACTIVITY
Each month will have different numbers of rows (approx 20,000) but it is probably safe to assume that the last month will have all the data rows in.
I would like an output in exactly the same format only with the YTD fields replaced by in-month equivalents.
Have I given you enough information to give me a tip on how to construct my query?
Thanks