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

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

Re: Selecting a value from a particluar record number/Quartiles

Show all headers | View raw

Also, I believe "Value" is an Access reserved word, and using it as a 
variable name can, though it won't necessarily and consistently, cause 
"unexpected results".  Access MVP Allen Browne has an "issue checker" that 
checks for things that potentially can cause problems in your database. 
Among many other things, it checks for improper use of reserved words. 
You'll find it at:

     http://allenbrowne.com/appissuechecker.html

 Larry Linson
 Microsoft Office Access MVP

"Laura" <laurajayne.cozens@peterborough.gov.uk> wrote in message 
news:fbb8fa76-22e4-4a77-94f2-df0e5f8e726e@a17g2000yqn.googlegroups.com...
> Hi,
>
> I have a table with two columns of data: LA and VALUE.  The column is
> sorted by VALUE, in ascending order.
>
> I have a recordset that counts the number of records in the table and
> stores this as a variable (TotalRecords).  I have another variable
> that calculates the record that is 1/4 of the way down (Quart1 =
> TotalRecords / 4)
>
> I now need to be able to select the VALUE from the table where the
> record number = QUART1 and store this value as another variable (for
> use in reports, queries and a table later on).
>
> Is this possible or is there a better way to do this?  I havent got a
> sort id in the table - is this the only way to do it?  If so, is there
> a better way to add a a sort id to a table automatically using VBA
> code?
>
> Many thanks
>
> Laura 

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

Thread

Selecting a value from a particluar record number/Quartiles Laura <laurajayne.cozens@peterborough.gov.uk> - 2011-03-31 10:34 -0700
  Re: Selecting a value from a particluar record number/Quartiles "James A. Fortune" <CDMAPoster@FortuneJames.com> - 2011-03-31 12:28 -0700
  Re: Selecting a value from a particluar record number/Quartiles "Access Developer" <accdevel@gmail.com> - 2011-03-31 21:33 -0500
    Re: Selecting a value from a particluar record number/Quartiles Laura <laurajayne.cozens@peterborough.gov.uk> - 2011-04-01 02:21 -0700
      Re: Selecting a value from a particluar record number/Quartiles "James A. Fortune" <CDMAPoster@FortuneJames.com> - 2011-04-01 12:23 -0700

csiph-web