modify a query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need change a query, but I am not sure how to do. Please someone give a
advice, thank you.

current query: get the "company name" which has "deal" in "the particular
year".
new query: get the "company name" with or without "deal" in the "particular
year".

the "deal" is identify by the deal date, so current query will get rid of
the company without deal date in that year.

fox
 
To help us help you, we need to see the SQL. Open the current query in design
mode. Go to View, SQL View. Cut and paste the SQL here.

As a matter of routine, never change a query, form, report, table etc.,
unless you have made a backup first either of the particular object or the
entire database. While in design mode of the query, you can do a File, Save
As to a different name for safekeeping. That simple advice has saved my bacon
many times.
 
Back
Top