Re: acces qry

Hi



You could use an inner join that "makes" the "lookup":


SELECT Bills.billNumber, Clients.clientName
FROM Bills INNER JOIN Clients
ON Bills.ClientID = Clients.ClientID


Assume you have a table Bills with fields billNumber and ClientID but,
rather than displaying ClientID, you wish to display the client Name. You
then have to make a "lookup" in table Clients, for the said ClientID value,
and retrieve the ClientName.



Hoping it may help,
Vanderghast, Access MVP


"nishashanoj" <nishashanoj.1ujbez@xxxxxxxxxxxxxxxxxx> wrote in message
news:nishashanoj.1ujbez@xxxxxxxxxxxxxxxxxxxxx
>
> I want to put look up in the access query.how is it possible.?
>
>
> --
> nishashanoj
> ------------------------------------------------------------------------
> nishashanoj's Profile: http://www.msusenet.com/member.php?userid=742
> View this thread: http://www.msusenet.com/t-1871003182
>


.

Relevant Pages

  • Re: CONCAT
    ... through records and concatenate the values until the ClientID changes. ... MS Access MVP ... Duane Hookom wrote: ... you would create a recordset and loop through it. ...
    (microsoft.public.access.queries)
  • Re: Auto rating a client with collected points base a Rating table
    ... SELECT ClientID, POIN, SetRate ... Vanderghast, Access MVP ... > rate them base on a rating table, but rating field I can manual over write ...
    (microsoft.public.access.queries)
  • Re: Max function
    ... Post the SQL statement of the query that is giving you the error. ... <MS ACCESS MVP> ... > joining the two on ClientID, that gives me a list of every appointment ... > only the most recent appointment I've had with each client, ...
    (microsoft.public.access.gettingstarted)
  • Re: Combining 2 or more records become 1 record
    ... Michel Walsh wrote: ... field, per ClientID. ... Vanderghast, Access MVP ...
    (microsoft.public.access.queries)