V
Vloed
Hello. I've been designing in Access for quite a while, but I write very
little SQL. What is the method of returning a note that is associated with
most recent date and time fields, and adding it to another query? I am
building a query to return fields from four tables. The first three are
easy. They are related one-to-one and selection is simple. The fourth
table, which contains the notes and their associated dates and times, by
department, is on the many side of a one-to-many relationship with the first
table which relates all of the tables. Do I need to 1) concatenate the
separate time (medium) and date (short) fields - how? 2) use the Max
function on the resulting date/time field - how? 3) show the note that is
associated with the most recent date/time in a row with the results from the
easier query - how? The result will be an editable query that looks like
what my people call a production log. Help on any part would be appreciated.
Thank you in advance.
little SQL. What is the method of returning a note that is associated with
most recent date and time fields, and adding it to another query? I am
building a query to return fields from four tables. The first three are
easy. They are related one-to-one and selection is simple. The fourth
table, which contains the notes and their associated dates and times, by
department, is on the many side of a one-to-many relationship with the first
table which relates all of the tables. Do I need to 1) concatenate the
separate time (medium) and date (short) fields - how? 2) use the Max
function on the resulting date/time field - how? 3) show the note that is
associated with the most recent date/time in a row with the results from the
easier query - how? The result will be an editable query that looks like
what my people call a production log. Help on any part would be appreciated.
Thank you in advance.