Linking Tables... HELP

[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!!

 

[Jerry Whittle]

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?

 

[Bob Barrows]

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)

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.

 

[MarieG]

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