tturner

I know, I let access assign keys. Great idea, I will separate the name in Excel! Sometimes I experience brain freezes.

Hi, I'm new to writing SQL, kind of learning on my own....My problem is I have two tables in access that both contain student data. Both tables may contain records on the same student. I want to merge those records in a report. There is nothing in either table that uniquely identifies each student except perhaps the DOB, but a student w/diff name could also have this DOB. For example:Table 1Student Name Student DOB Some other info... smith, jane 01/01/97doe, todd 01/01/97smith, kim 03/07/92Table 2Student Name Student DOBsmith, jane a 01/01/97brown, joe 06/18/95I want to merge Jane Smith's record from both tables, but her name has a middle initial included in the 2nd table so I don't know how to write a statement to include her in my report! Help!!!Please tell me how to write a statement