Would you make a new table? The table that I have holds
these 6 columns and has the primary key on the Account
Number. I was trying to avoid having multiple Account
Numbers to go along with each contact. Could you explain
why you would do it this way?

Thank you for your advice! I appreciate it!

-----Original Message-----
Normalize your data into records rather than repeating
fields. Is this a
possibility? I wouldn't go any further without making
changes.

--
Duane Hookom
MS Access MVP


wrote in message
...
I have 6 columns with Contact information and 6 date
columns. (ie. Contact One, Contact One Date, etc.)
How do I return the latest Contact and Date.

An example: (These are all seperate columns)

1st Contact - Bill Walsh 1st Contact Date - 1/11/2004
2nd
Contact - Joe Theisman 2nd Contact Date - 1/18/2004 3rd
Contact - Joe Montana 3rd Contact Date - 1/27/2004

How do I have it return Joe Montana 1/27/2004 in a
query?

Thanks,



.