Auto-select the highest of a range of parameters

Welcome Guest! To enable all features please Login or Register.

Notification

Error

Auto-select the highest of a range of parameters

Options

Previous Topic Next Topic

paul.livsey		#1 Posted : Thursday, May 3, 2012 11:24:22 PM(UTC)
Rank: Newbie Reputation: Groups: Registered Posts: 3 Location: Perth, WA, Australia		Hi all, I'm working on some acid sulfate soils projects, and have results from both SPOCAS and Scr suites in my database. I'm producing the data tables without any troubles, but i was wondering if ESdat has the ability to add one more column to the table called "Highest Net Acidity", and populate it with the highest value from the acidity parameters reported in each suite? Regards, Paul
		WWW

User Profile View All Posts by User View Thanks


	Wanna join the discussion?! Login to your ESdat Forums forum account or Register a new forum account.

Support		#2 Posted : Friday, May 4, 2012 6:52:46 AM(UTC)
Rank: Administration Reputation: Groups: Registered, Administrators Posts: 259 Location: Ballina Was thanked: 8 time(s) in 8 post(s)		Hello Paul, Can I clarify, you have multiple Acidity results, with different ChemNames/Different ChemCodes, and you want to produce an additional output which has the maximum of those results? Post-Import Custom Calculations are probably the best, or only, way to get the system to do that automatically. Alex


User Profile View All Posts by User View Thanks

paul.livsey		#3 Posted : Friday, May 4, 2012 7:34:17 PM(UTC)
Rank: Newbie Reputation: Groups: Registered Posts: 3 Location: Perth, WA, Australia		Hi Alex, Thanks for your quick reply. That is exactly what I'm after - could you please point me towards some instructions to carry this out and insert an additional column with this data to the chem tables? Thanks, Paul
		WWW

User Profile View All Posts by User View Thanks

Support		#4 Posted : Monday, May 7, 2012 9:48:40 PM(UTC)
Rank: Administration Reputation: Groups: Registered, Administrators Posts: 259 Location: Ballina Was thanked: 8 time(s) in 8 post(s)		Hello Paul, The best way to learn how to construct Post Import Custom Calculations is to open an existing one, and review the logic. Have a read of http://www.ESdat.net/ESd...ostimportcalcs.htm It does require some knowledge of creating the calculation in the syntax of the database you use (ie MS Access or SQL Server). For some people that is a problem, in which case we also offer a service in creating them for a fee. Let me know if that is required. Alex


User Profile View All Posts by User View Thanks

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.