Hall of Fame

1. capricorn12,136,854
2. DatabaseMX1,791,758
3. LSMCons...1,256,766
4. boag20001,036,189
5. peter57r799,346
6. matthews...688,896
7. rockiroads574,427
8. thenelson445,637
9. GRayL434,146
10. TextReport434,053
11. puppydog...400,608
12. tbsgadi367,274
13. JDettman322,461
14. cactus_d...281,926
15. mbizup243,682
16. jimpen211,515
17. harfang207,824
18. GrahamM...183,618
19. Helen_Fe...177,740
20. LPurvis165,663
21. angelIII146,835
22. hnasr137,021
23. kelvinsparks136,703
24. Tramtrak136,379
25. mildurait128,151

1. capricorn113,063,646
2. DatabaseMX6,134,612
3. rockiroads6,047,347
4. nico50385,705,281
5. LSMCons...5,307,939
6. peter57r5,070,812
7. LPurvis3,627,703
8. harfang3,312,263
9. shanesue...3,288,317
10. GRayL3,271,116
11. stevbe2,861,511
12. jimhorn2,807,017
13. boag20002,733,425
14. matthews...2,521,203
15. mbizup2,374,174
16. thenelson2,146,006
17. flavo2,117,383
18. jadedata1,968,277
19. jefftwilley1,887,172
20. puppydog...1,849,966
21. cactus_d...1,681,384
22. eghtebas1,534,843
23. JDettman1,468,976
24. jjafferr1,340,995
25. dannywar...1,329,637

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

5.2

Reseting the Waiting List clock

Asked by peterjerry in Microsoft Access Database

I need a solution for calculating the waiting list of outpatients in a clinic. I have the referral number which is unique to one patient. A patient will have several contacts over several months and based on the status, the patients waiting list clock is reset. I have mentioned what needs to be done each time a status is encountered. I need a vba script which can update the table I have shown below.

If Status is
711 copy the date value in the previous row of the WaitStartDate column.
712 - copy the date value in the previous row of the WaitStartDate column.
713 Insert the contact date in the same row to the WaitStartDate, come out of the loop, look at the next reference number.
714 - copy the date value in the previous row of the WaitStartDate column.
715 reset the WaitStartDate as the contact date(of the same row).
716 reset the WaitStartDate as the contact date(of the same row)
717 - copy the date value in the previous row of the WaitStartDate column.

If the first one is 711, 712, 714, 717 copy the REFERRAL_DTE to the WaitStartDate

ref.no referral date      contact date      status      WaitStartDate
168927      19/04/2004      12/10/2004      711
168934      20/04/2004      12/05/2004      715
168934      20/04/2004      09/06/2004      715
168934      20/04/2004      29/07/2004      715
168934      20/04/2004      23/09/2004      716
168934      20/04/2004      07/10/2004      713
168934      20/04/2004      09/12/2004      711
168944      20/04/2004      22/06/2004      713
169006      21/04/2004      07/06/2004      713
169006      21/04/2004      16/08/2004      713
169006      21/04/2004      18/10/2004      713
169006      21/04/2004      13/12/2004      717
169006      21/04/2004      20/12/2004      712
169018      16/04/2004      18/05/2004      714
169018      16/04/2004      25/05/2004      713
169018      16/04/2004      01/06/2004      716
169018      16/04/2004      08/06/2004      713
169018      16/04/2004      15/06/2004      713
169018      16/04/2004      22/06/2004      716
169019      21/04/2004      26/05/2004      713
169019      21/04/2004      07/07/2004      713
169019      21/04/2004      04/08/2004      713
169019      21/04/2004      29/09/2004      717
169019      21/04/2004      13/10/2004      715
169026      21/04/2004      28/06/2004      717
169026      21/04/2004      11/10/2004      716
169028      21/04/2004      26/07/2004      715

View the Solution FREE for 30 Days

20091118-EE-VQP-93

Reseting the Waiting List clock

Asked by peterjerry in Microsoft Access Database

About this solution