Re: lookup of Excel to Access

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

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 05:14:39 -0700

Erwin

First, you'll need a table that holds the values you'll be "looking up".

Then, create a query that is sorted in the order you need.

Finally, in your query, you want the largest value that is <= your
criterion. You can parameterize this for user input, or you can use a form
to "collect" the comparison, and your query can use an expression to refer
to the form control's value. 

-- 
Good luck
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: Eliminating Duplicate Items in a Query
    ... Create a query that returns all the names. ... >> Jeff Boyce ... >> <Access MVP> ... >>>> Without a look at the underlying SQL statement, ...
    (microsoft.public.access.queries)
  • Re: Whats fastest Unique Values or Group by?
    ... "Hallgeir" wrote in message ... >> Jeff Boyce ... >> <Access MVP> ... >>> I have a query with two output fields and a lot of records. ...
    (microsoft.public.access.queries)
  • Re: query insert data problem
    ... > my table as the fields: Main date, product code, quantity ... > i want a query with the result to be: ... > "Jeff Boyce" wrote: ... >> <Access MVP> ...
    (microsoft.public.access.queries)
  • Re: HELP! Using VB to alternate fields.
    ... afraid I'm still not following you... ... > "Jeff Boyce" wrote: ... >> query to do the calculations... ... >> <Access MVP> ...
    (microsoft.public.access.modulesdaovba)
  • Re: Get more than one line per item in list box?
    ... Jeff Boyce ... <Access MVP> ... "scjanner" wrote in message ... > I'm using a query to generate results that are longer than the width of ...
    (microsoft.public.access.forms)