Latest activity

  • AngelSpeaks
    For all those who believe that Trump incited his followers to violence on January 6th, was this one of the type of videos you watched...
  • The_Doc_Man
    The_Doc_Man replied to the thread Query problem using "last".
    I don't. You don't. MSFT? No confidence in how they treat things. Why do you think that Access and Excel have different date...
  • The_Doc_Man
    The_Doc_Man replied to the thread Query problem using "last".
    Not what I meant, @arnelgp - this has to do with the rules of shared DBs in which one user is updating a record while another user is...
  • arnelgp
    arnelgp replied to the thread Query problem using "last".
    if you acquire something, say a house, or a car, i am sure you get the "house plan" or the car manual. it include the technical manuals...
  • The_Doc_Man
    OK, I'll be the one to toss the stink bomb. Your tables do not appear to be structurally correct. They are not normalized. You...
  • arnelgp
    arnelgp replied to the thread Query problem using "last".
    test it first. add a record one by one. Create a query that uses Last("yourFieldName") against your table and save the query (qryLast)...
  • The_Doc_Man
    The_Doc_Man replied to the thread Hi Folks!.
    A lot of the folks we picked up from UA may be contributors to that situation - and I welcome them, because I've been distracted lately...
  • The_Doc_Man
    The_Doc_Man replied to the thread Query problem using "last".
    I know that MSFT acquired Access via their usual method - they bought out the company that made it. (You can look that up on...
  • arnelgp
    arnelgp replied to the thread Query problem using "last".
    For the sake of argument, supposed your table does not have autonumber field or any numeric field. what you have is FirstName and...
  • S
    sonic8 reacted to MajP's post in the thread Query problem using "last" with Like Like.
    One thing that has been said here is that First() and Last() will return the first record added or the last record added. That is...
  • S
    sonic8 reacted to DHookom's post in the thread Query problem using "last" with Like Like.
    In three decades of using MS Access, I don’t recall ever using last. I always find the max of a date field value in a query to identify...
  • Doozer
    Doozer reacted to NauticalGent's post in the thread Hi Folks! with Like Like.
    Exactly!
  • Doozer
    Doozer reacted to Richard Rost's post in the thread Hi Folks! with Like Like.
    Greetings! I lurk here myself as well. Been poking around for a few years. But it seems like every time I find a question I can answer...
  • DHookom
    DHookom reacted to MajP's post in the thread Query problem using "last" with Like Like.
    One thing that has been said here is that First() and Last() will return the first record added or the last record added. That is...
  • Ken Sheridan
    Ken Sheridan replied to the thread Query problem using "last".
    Let's assume that, in a table in which the DateTimeStamp column is assigned its value by its DefaultValue property, user A navigates to...
Back
Top Bottom