Add Table to Select query

From: Mary (Mary_at_discussions.microsoft.com)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 11:21:05 -0800

I have a select query with the following statement:

SELECT DISTINCT Customers.CustomerName, Customers.Type,
Customers.GlobalName, Customers.Email, GlobalCompare.ImportedCustomerName
FROM GlobalCompare INNER JOIN Customers ON
GlobalCompare.ImportedCustomerName Like Customers.CustomerName & "*"
ORDER BY Customers.Type, Customers.CustomerName
WITH OWNERACCESS OPTION;

There is a new Table which also has the CustomerName field. How can I
include the CustomerName field from the new table in this query?

Thank you,
Mary

Relevant Pages

  • Re: Using Start Date and End Date in Query
    ... ActualRevenue is the actual revenue for the customer in the period? ... it must not be stored in the PotentialRevenue table. ... Use a query to calculate the actual revenue. ... >>>>> boxes for the StartDate, EndDate and CustomerName, ...
    (microsoft.public.access.queries)
  • Re: Query not populating form
    ... I have tried putting my query as the record source of the form to no avail. ... first row from the CustomerName tbl. ... selection of a different customer. ...
    (microsoft.public.access.formscoding)
  • Re: Query not populating form
    ... City, State, and Zip Code from the CustomerName table. ... I thought if I created a query on a single table then ... If you made the query the RecordSource of the form then it sounds like you want ... If so the ComboBox should be unbound and it ...
    (microsoft.public.access.formscoding)
  • Re: Query not populating form
    ... the last choice in the wizard. ... the process is a user selects a CustomerName ... I know that I need to create a query of some sort to relate the ... If so the ComboBox should be unbound and it ...
    (microsoft.public.access.formscoding)
  • RE: Create report with three rows of data representing years
    ... "ChuckW" wrote: ... Chuck W ... Feb07query has CustomerName, CustomerId and the every month as a field. ... table with a union query and then create a crosstab based on your union query. ...
    (microsoft.public.access.reports)