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
> Not Even Sure This Can Be Tabled..., Access 2016    
 
   
NewIdeas
post Dec 23 2019, 04:46 PM
Post#1



Posts: 13
Joined: 19-December 19



I have a bunch of rules for testing the input of water tests against.

CODE
'Rule 1 FAC can never be more than TCC
    'TCC measures all including FAC therefore it is impossible for FAC to be more than TCC
    
    'Rule 2 it is unlikely a pH of greater than 7.8 with a TA less than 50
    'The exception is if the algal bloom
    'and the pH can be above 8.2 and TA will read very low if at all
    
    'Rule 3 pH cannot exceed 8.2 with any TA >40
    ' pH remains <8.2
    
    'Rule 4 if the TA >CH
    'Must cut TA well below CH first before adding chemical


I was thinking I would hard code these and then had a second think...maybe some time in the future a new rule may need to be added. Be better to set up a table to hold the rules but the rules are all slightly different structures. I dont see how I could tabulate this short of perhaps SQL statements?

Any ideas anyone?

Go to the top of the page
 
June7
post Dec 23 2019, 05:08 PM
Post#2



Posts: 1,312
Joined: 25-January 16
From: The Great Land


I have procedure to classify soil samples. A very long procedure of If Then Else branching to code decision logic. I would never attempt to 'tabulate' this.

What is output goal for your analysis - multiple decision outputs?

Can certainly have table with standards that samples must meet which allows to easily modify the standard values. Then code uses appropriate fields in expressions.

This post has been edited by June7: Dec 23 2019, 06:07 PM

--------------------
Attachments Manager is below the edit post window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Go to the top of the page
 
projecttoday
post Dec 23 2019, 05:57 PM
Post#3


UtterAccess VIP
Posts: 11,809
Joined: 10-February 04
From: South Charleston, WV


Can you design such a table? Give it a shot. This isn't a programming question. It either makes sense to make a table or not.

ph low / ph high / TA high / TA low

?

But if instead of a value you're pointing at another column in some cases but not others, then that's a problem. Maybe it can be partly table-ized.

--------------------
Robert Crouser
Go to the top of the page
 
kfield7
post Dec 23 2019, 06:40 PM
Post#4



Posts: 1,058
Joined: 12-November 03
From: Iowa Lot


You could possibly store the parameter name in the table, and use eval() in the query.
Go to the top of the page
 
NewIdeas
post Dec 30 2019, 03:50 PM
Post#5



Posts: 13
Joined: 19-December 19



Thats kind of what I was asking...Can someone see a table design here, as I can see the table for the first one...but the others?
Go to the top of the page
 
projecttoday
post Dec 30 2019, 07:23 PM
Post#6


UtterAccess VIP
Posts: 11,809
Joined: 10-February 04
From: South Charleston, WV


Then again maybe you could. Can you have a column for every single question even if a great many of the questions don't apply to many of the entries? (They would have "NA" entered. Or left null.) Could this work?

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    5th April 2020 - 01:41 AM