In Access how can I get the First entry of a linked table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to pull the first appearance of the "Activity ID" but I keep
getting all the records instead. I'm using a select query and using the first
function but it still is not working. The reason I only the first appearance
of the Record is so I know when it was entered into our system the first
time. I'm not sure if any of this is making sense. I might be trying to do
something that isn't possible. I need help!
 
I'm trying to pull the first appearance of the "Activity ID" but I keep
getting all the records instead. I'm using a select query and using the first
function but it still is not working. The reason I only the first appearance
of the Record is so I know when it was entered into our system the first
time. I'm not sure if any of this is making sense. I might be trying to do
something that isn't possible. I need help!
Click to expand...

The First() function is misleading. It does NOT return "the first
record entered" reliably - it might, but you can't count on it! It
returns the first record *in disk storage order*, an order that may
change if you Compact the database or if you have deleted and then
added records.

What defined a record as being "the first", based on actual field data
stored in the record? Unless you have something which provides this
information you're out of luck - an Access table is an unordered "bag"
of data with no controllable first or last record.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top