Linking Tables... HELP

  • Thread starter Thread starter MarieG
  • Start date Start date
M

MarieG

I have 2 tables being linked by and ID number, a join so that it includes ALL
data from Tbl 1, and then the data that corresponds to it in table 2... It
works great, except that the data from table 2 links correctly to the ID
number, but not the date.. example:

How it is:

ID Date Data
1 1/1/09 Purple
1 2/1/09 Purple

How it should be:

ID Date Data
1 1/1/09 Purple
1 2/1/09 (blank)


I'm clueless.. pls help

Thanks!!
 
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

Are you really, really sure that there isn't a "1 2/1/09 Purple" record?

Are you using lookup tables?
 
MarieG said:
I have 2 tables being linked by and ID number, a join so that it
includes ALL data from Tbl 1, and then the data that corresponds to
it in table 2... It works great, except that the data from table 2
links correctly to the ID number, but not the date.. example:

How it is:

ID Date Data
1 1/1/09 Purple
1 2/1/09 Purple

How it should be:

ID Date Data
1 1/1/09 Purple
1 2/1/09 (blank)
Click to expand...
Switch your query to SQL View (using the View menu, or the toolbar
button, or the right-click context menu) and copy-paste the sql
statement so we can see what you've done.
 
Ok.. I fixed that one.. I didn't know that you could do 2 outer joins...
THAT IS AWESOME BY THE WAY!!! :)

Thanks, and sorry about that..

Marie
 
Back
Top