Results 1 to 4 of 4
  1. #1
    intexumax is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Feb 2013
    Posts
    2

    to show only last record from a table


    hi there,
    my table entries are reciept(primary key),name,reciever,address,amount...i want a query to show recently updated entry in table i.e only last entry from table

  2. #2
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Till some one comes along, how do we know which is the last updated entry ?

    Thanks

  3. #3
    intexumax is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Feb 2013
    Posts
    2
    i dint get what ur trying to say

  4. #4
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    sorry, for not being clear.
    What I was asking was :
    How do we let access know which is the last updated entry in the table ?
    Do we have a field for example : LastUpdatedOn - DateTime Field or a DateTime Field set with a default value of Now, etc ?
    Or is it that you have just updated an entry & want to open it immediately along with the updated data ?

    Thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Show same record once on the top
    By dmarques in forum Reports
    Replies: 2
    Last Post: 06-26-2012, 03:39 AM
  2. Show Only One Occurrence of a Record
    By tsn.s in forum Queries
    Replies: 1
    Last Post: 04-23-2012, 09:29 AM
  3. Replies: 1
    Last Post: 04-11-2012, 03:30 PM
  4. Replies: 3
    Last Post: 09-29-2010, 08:31 AM
  5. Replies: 4
    Last Post: 10-29-2008, 11:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums