Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #9306

Re: help with finding highest value

Show all headers | View raw

I think you would benefit from one of several relational database design 
books on the market. Your problem is harder than it should be because your 
database does not follow relational design guidelines...

-- 
Larry Linson
    Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"bobh" <vulcaned@yahoo.com> wrote in message 
news:6c235789-3f8e-4bf3-8007-18acc305e045@googlegroups.com...
> Hi All,
>
> Anyone got vba they would share to figure out the following;
>
> in A2007 I have a table, 6 fields
> field names are --> QCode, Val1, Val2, Val3, HighestVal, WhichVal
>
> for each QCode I need to figure out which of the 3 Val fields has the 
> highest value in it and update the HighestVal field with that value and 
> update WhichVal field with what val field the highest value was in.......
>
> so;
> QCode  Val1  Val2  Val3  HighestVal WhichVal
> 12398  23.7  54.2  39.0     54.2      Val2
> 43659  67.8  37.3  78.1     78.1      Val3
>
> thanks in advance
> bobh. 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

help with finding highest value bobh <vulcaned@yahoo.com> - 2014-04-22 10:03 -0700
  Re: help with finding highest value "Phil" <phil@stantonfamily.co.uk> - 2014-04-22 19:02 +0100
    Re: help with finding highest value bobh <vulcaned@yahoo.com> - 2014-04-22 11:56 -0700
  Re: help with finding highest value Ron Weiner <rw@domain.com> - 2014-04-22 20:57 -0400
  Re: help with finding highest value "Access Developer" <accdevel@gmail.com> - 2014-04-29 15:44 -0500
  Re: help with finding highest value DFS <nospam@dfs.com> - 2014-04-30 15:00 -0400
    Re: help with finding highest value DFS <nospam@dfs.com> - 2014-05-02 01:33 -0400

csiph-web