Re: query from two tables

From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 11/26/04 

Date: Fri, 26 Nov 2004 15:41:47 -0500

You need three joins between the "order" table and the other table/query.
Sounds as if you've got just one. Join all the fields that need to match
between the two source tables. After you do this, you should see three
joining lines in the design view. 

-- 
        Ken Snell
<MS ACCESS MVP>
"Jack" <Jack@discussions.microsoft.com> wrote in message
news:63776174-9EB6-416C-9E9E-F6BC94ABE600@microsoft.com...
> Database for vendors that represent different websites in different states
> and counties. I have a query that will list all vendors from various
> websites, states, counties. Some vendors are members of different sites
and
> or states. The query works perfect for the information that I need.
However I
> am having difficulty 'matching' a single record with single record in
another
> table. The other table has three fields (order_website, order_state,
> order,county) How can I run a query against the ALL query/table. Currently
> what happens is that it will show everyone that is part of either
> website_name, or state, or county. I need this to break it down to a
single
> record
>
> Can I ceate some criteria that says that
> order_website,order_state,order_county in the order table HAVE to match
> website_name, state, county in the all salesmen table/query?
>
> Thanks,
> Jack

Relevant Pages

  • RE: Need to Hard Code in Combo Boxes Instead of using a lookup tab
    ... table/query. ... When you talk about the make table query with People_tbl primary key - what ... weekly and monthly hours in separate fields, put them there from the first ...
    (microsoft.public.access.formscoding)
  • Re: Selection criteria on parameter forms
    ... Work with the form first. ... The search form is bound to a table/query. ... The fields you wish to filter on need to be in that table/query. ... I can't even get the query to run properly, ...
    (microsoft.public.access.formscoding)
  • Re: Adding fields from a different query
    ... How do I drop fields from table/query #2? ... Change your first query to include the extra fields. ... Disclaimer: This author may have received products and services mentioned ...
    (microsoft.public.access.forms)
  • Re: option and combobox cascade
    ... I don't understand what you mean by "a row in a query which i want to ... If the combo box's RowSourceType is Table/Query, ... If you're getting an error message, ...
    (microsoft.public.access.forms)
Loading