高手请帮助,不甚感激!我想把每个no前3天的服药剂量累加起来,但每个no起始服药时间并不相同,请问应该怎么办呢?请帮助我谢谢!
数据如下:
| no1 | xingbie | fydate | fyjl |
| 4401032200533 | 1 | 2010-8-13 | 30 |
| 4401032200533 | 1 | 2010-8-14 | 40 |
| 4401032200533 | 1 | 2010-8-15 | 45 |
| 4401032200533 | 1 | 2010-8-16 | 55 |
| 4401032200533 | 1 | 2010-8-17 | 55 |
| 4401032200533 | 1 | 2010-8-18 | 55 |
| 4401032200535 | 1 | 2010-9-15 | 60 |
| 4401032200535 | 1 | 2010-9-16 | 60 |
| 4401032200535 | 1 | 2010-9-17 | 60 |
| 4401032200535 | 1 | 2010-9-18 | 60 |
| 4401032200535 | 1 | 2010-9-19 | 60 |
| 4401032200535 | 1 | 2010-9-20 | 55 |
| 4401032200535 | 1 | 2010-9-21 | 55 |
| 4401032200536 | 1 | 2010-12-29 | 75 |
| 4401032200536 | 1 | 2010-12-31 | 75 |
| 4401032200536 | 1 | 2011-1-5 | 75 |
| 4401032200536 | 1 | 2011-1-7 | 75 |
| 4401032200536 | 1 | 2011-1-9 | 75 |
| 4401032200536 | 1 | 2011-1-12 | 75 |
| 4401032200536 | 1 | 2011-1-13 | 75 |
| 4401032200536 | 1 | 2011-1-15 | 75 |
| 4401032200536 | 1 | 2011-1-17 | 75 |
| 4401032200536 | 1 | 2011-1-19 | 75 |
| 4401032200536 | 1 | 2011-1-20 | 75 |
******************************************************************************