Latest activity
-
arnelgp replied to the thread Query problem using "last".i don't know why are comparing excel against access. just prove that Last("FieldName") is not returning the "Last saved New record". you... -
The_Doc_Man replied to the thread Query problem using "last".Arnel, I first opened Excel and Access simultaneously. I opened the VBA window, opened the immediate window, and did a debug.print on... -
-
arnelgp replied to the thread Query problem using "last".just tested it both, in Excel VBA and Access VBA: format(cdate(0),"mm/dd/yyyy") they both return: 12/30/1899
-
arnelgp replied to the thread Query problem using "last".that is way off this topic.
-
AngelSpeaks reacted to Isaac's post in the thread Today's Environmentalists Are Really Luddites with
Like.
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 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 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 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 replied to the thread Adding values when importing data.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 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 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 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 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...
-
SOne thing that has been said here is that First() and Last() will return the first record added or the last record added. That is...
-
SIn 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...
