Sort Table & Pull most recent record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kaseano - 30 May 2007 16:25 GMT

I'm using a table to transfer data between forms,

This table periodically has new records put into it, & I was wondering how
to pull the most recent record

I'm not sure what the statement would be to pull the fields from that one
record into a variable
x = [field] of that first record.

Thanks so much for any help--

Reply to this Message

John W. Vinson - 30 May 2007 19:10 GMT

>I'm using a table to transfer data between forms,

You're mistaken.

Forms *do not contain data*, any more than my office window "contains" the
Owyhee Mountain range.

Forms are just windows which *display* data, which is stored in a table, and
only in a table.

>This table periodically has new records put into it, & I was wondering how
>to pull the most recent record

Base the Form on a Query with a criterion

=DMax("[datefield]", "[tablename]")

on the date field, to select only the most recent record in the table.

>I'm not sure what the statement would be to pull the fields from that one
>record into a variable
>x = [field] of that first record.

I have no idea what you're asking here.

John W. Vinson [MVP]

Reply to this Message