On 3/18/2010 3:33 PM, Jeff Boyce wrote:
Wes

Access tables store data rather like "buckets o' data". That is, there's no
inherent (human-perceptible) order. Thus, the "Last" record only makes
sense if YOU have imposed some sort order.

What you YOU mean by "last"?

Regards

Jeff Boyce
Microsoft Access MVP

I need to ADD a new employee. In the Access manual, looking at the
sequence of events, it indicates that using the OPEN event you can
determine if this is a "new" reocrd. If so, you need to move to the end
of the recordset. Otherwise you will continue to use the first record.

Unfortunately, I am at a big disadvantage. I have several years of
experience using the "big" relational databases, Oracle, Sybase, DB2,
etc., and the programming is completely different. I am trying to learn
to use ACCESS for a small business I am starting. At the moment it is
challenging, but it looks like a really cool facility that has a lot of
power.

Oh, I do have some small amount of VBA experience, but that is from the
EXCEL perspective.

Thanks for the help

Wes