Query Help Please.

[Golfinray]

I have a main database that contains around 3000 projects. I have another
database that we use to track projects. The school districts have deleted
their 06-07 projects from the main database. I still have those projects
listed in the tracking database. There are around 1000 06-07 projects in the
tracker. I have tried adding the 3000 2008 through 2011 project ID #s from
the main database to the 1000 project ID #s from the tracker with a union
query so that I could get all projects to query on one sheet. I kept coming
up with 6000-7000 numbers but there are only around 4000. I'll post my sequel
back if need be. I'm also struggling to get 4000 projects to show up even
using the flawed 6000 project number union query. Help!Thanks!

 

[Golfinray]

That got it Karl! Thanks a bunch!!!!

Try this --
SELECT [New Project ID#]
FROM [7891011 project numbers]
UNION SELECT [00_projects webtool and tracker].[cp_number]
FROM [00_projects webtool and tracker];

--
KARL DEWEY
Build a little - Test a little

SELECT [New Project ID#]
from [7891011 project numbers]
UNION ALL select [00_projects webtool and tracker.cp_number]
from [00_projects webtool and tracker];

Post your SQL.
--
KARL DEWEY
Build a little - Test a little


:

I have a main database that contains around 3000 projects. I have another
database that we use to track projects. The school districts have deleted
their 06-07 projects from the main database. I still have those projects
listed in the tracking database. There are around 1000 06-07 projects in the
tracker. I have tried adding the 3000 2008 through 2011 project ID #s from
the main database to the 1000 project ID #s from the tracker with a union
query so that I could get all projects to query on one sheet. I kept coming
up with 6000-7000 numbers but there are only around 4000. I'll post my sequel
back if need be. I'm also struggling to get 4000 projects to show up even
using the flawed 6000 project number union query. Help!Thanks!