Search results

Funny you mention that! I was using a temp table to hold the data to populate a report. While I was working it out (about a year ago), I thought that would be the easiest way to go. At some point today, while I was mucking about, I realized I could just use the query as a select and base the...

Hi Paul, yeah...not sure what happened there. I had pasted it into Excel and the did a copy and paste. I didn't see the garbage until after I had posted.

Hi Dave, something in your replies made the light bulb go off in my wee brain. The only time I got bad results was when the "next" record and the same StartDate - in my test data, 12/11/2025. Here is the revised query and it is working (for now!) INSERT INTO tmp_TimeInPhase (PRON...

I am having a problem with this query, it is giving me the wrong results. INSERT INTO tmp_TimeInPhase (PRON, [TimeStamp], [Current Proc Point], ProcPointStartDate, EndDate, TimeInProc, [Updated By], PALT) SELECT p.PRON, a.TimeStamp, c.[Current Proc Point]...

Welcome aboard!

Happy New Year, Prince George, Va. The weather here is a balmy 28f...frozen tundra as far as I'm concerned

Welcome aboard Alan, dive right in!

(y) (y) (y)

Thanks Tom, excellent explanation!

A very insightful, pragmatic and mature response. My personal journey with ChatGPT and Gemini has been favorable, especially with developing a very complex PowerShell script. I have to admit, it has made me very lazy when it come to writing VBA - it just does it faster. That being said, it can...

To you and yours as well Bob, hope it was a great ine!

This thread intrigued me, I had no idea what the actual problem was, so of course the solutions didn't clear it up for me either. I turned to ChatGPT and thought it might be prudent to share the conversation here: 🧠 Understanding BigInt Validation in Access VBA Why Fix() Is Interesting — and...

@mikekal , I think you have been hacked.

Welcome aboard!

Given our recent history, amen, amen and amen...

I disagree Angel, respectfully. We should always be willing to have a conversation if it can be kept civil and cerebral.

+1 on Paul's statement...

Sincerely sad to read this. I wish you and her all the best...

Welcome aboard, sound like Access is exactly what you need. Roll up the sleeves and get busy...

Welcome aboard, as you can see, some of us are acquired tastes, but the willingness to assist is genuine, that I can assure you.