UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Loop Access, Access 2016    
 
   
jeannier1975
post Apr 15 2019, 05:01 PM
Post#1



Posts: 18
Joined: 12-October 18



i am trying to figure out a way when a test result is positive for listeria that the test day goes back to day 1 .
Attached File(s)
Attached File  2019_04_15_14_19_13.jpg ( 274.54K )Number of downloads: 15
 
Go to the top of the page
 
MadPiet
post Apr 15 2019, 05:52 PM
Post#2



Posts: 3,002
Joined: 27-February 09



Any chance you can post some data? De-identify it if necessary. But your design is going to give you headaches. If you did it like
(PatientID, EventDate, Symptom, TestResult) then it wouldn't be that bad.

But looping? Only if I'm forced to. Performance when you write stuff like that will make you cry if you have a lot of data. Best off not to do that unless you don't have any other choice.
Go to the top of the page
 
PeterNRoth
post Apr 15 2019, 08:21 PM
Post#3



Posts: 1
Joined: 28-March 19



Perhaps treat the measurement as "Days since"?
Rather than back to day 1, dayCount = 0
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    24th April 2019 - 11:52 PM