Re: Using criteria in select query for recoding of variables

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,


Not sure I understand fully the problem. Is it a kind of "lookup" ? if so,
have a table that list the translations to be preformed:


Old ToBe ' fields name
1 A
2 A
3 B
4 C
5 C



and then, either a join, either a DLookup would do:



myNewValue = DLookup("ToBe", "tableNameHere", "Old=" & myOldValue )



Hoping it may help,
Vanderghast, Access MVP


"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF982982-1433-4D40-A634-97029B4F9EC6@xxxxxxxxxxxxxxxx
I am a very new user. I want to code the values of a new variable based on
the values of an old variable. For example 1 and 2 in old variable become
A
in new variable; 3 becomes B in the same new variable; and the value 4 and
5
in the old variable becomes C in the new variable.
--
Peter


.

Relevant Pages

  • RE: Flash disks and FFS layout heuristics
    ... create a forward lookup on-flash to complement the reverse lookup you ... (however many translations can be conveniently cached in system memory). ... In a small flash device the embedded application will determine whether ... Because you can cache new lookups in system memory and because you do ...
    (freebsd-arch)
  • Re: Newbie to Forums, SIMD question
    ... Peter Dove wrote: ... > for every pixel in order to apply a gamma value. ... To generate the lookup table (C code for a fixed 1001-entry table, ... This should leave you with a value of ~8-10 bits of precision. ...
    (comp.lang.asm.x86)
  • Re: DLookUp-Am Lost
    ... does not exist in ACCESS VBA itself. ... is quite different from what you show for LookUp attempt. ... the subform to the main form using the LinkChildFields and LinkMasterFields ... it's possible that DLookup may work for you. ...
    (microsoft.public.access.queries)
  • DLookup
    ... not then lookup the default values. ... you may want to consider using a CRS ... would be to use DLookup inside an NzFunction to return ... >All English courses use pink paper. ...
    (microsoft.public.access.queries)
  • Re: BizTalk 2004 :: business rules composer :: lookup operation
    ... Matt, ... If you store translations inside a db table and do a lookup like: ... > 3) Wrote a command line program to query SQL Server and get back the name ... >> I'm not enthused because its basically a db lookup shielded by the rules. ...
    (microsoft.public.biztalk.general)