most recent date

[Guest]

Ok, I have 2 tables now one with strictly dates. How do I get something to
show all my info from my main table(table 1) with a field that has info from
the other table (table 2). Only, I want it to search through table 2 and find
the most recent date then, depending on which field that is in either display
the field name, or something i tell it to automatically display which ever is
possible/easier. I'm thinking something with DateDiff() might be usefull, but
I don't have time to go through everything and figure this out. If someone
who is smart could figure it out and write the expression or what ever is
needed for me that would be great. Just tell me what to do. I don't want you
to think I am lazy, just I am really busy and this is like "extra" now unlike
the last 2 months. Thanks if you have a clue!!!

 

[John Vinson]

Ok, I have 2 tables now one with strictly dates. How do I get something to
show all my info from my main table(table 1) with a field that has info from
the other table (table 2). Only, I want it to search through table 2 and find
the most recent date then, depending on which field that is in either display
the field name, or something i tell it to automatically display which ever is
possible/easier. I'm thinking something with DateDiff() might be usefull, but
I don't have time to go through everything and figure this out. If someone
who is smart could figure it out and write the expression or what ever is
needed for me that would be great. Just tell me what to do. I don't want you
to think I am lazy, just I am really busy and this is like "extra" now unlike
the last 2 months. Thanks if you have a clue!!!

It sounds like you have multiple dates in different FIELDS in Table2.
If so, your database design is *WRONG* and is the source of your
problems! Access is designed (like all relational databases) to search
*down* a list of records, not *across* fields.

Could you explain the structure of your tables, and perhaps a bit
about the meaning of the fields in the real world?

I obviously cannot write the desired expression for you because...
ummm... I can't see your database, don't know what your table
structures or fieldnames are, and don't know what the scope of the
"latest" date search might be.

John W. Vinson[MVP]