Recent content by ClydeL

Thanks guys! I didn't realize that the time value would influence DateSerial like that. DateValue did the trick.:)

I've got a simple query against a single table and need to return records from the previous month. Searches have led me to believe that DateSerial is the way to go, but I've got an issue with it finding the last day of the prior month. Running Access 2019 on Win10. The following returns...

Hi all, I'm a moderately experienced SQL programmer that has moved on to a job that requires me to learn Access. I must admit that it has been fun, but at times frustrating. But everyday that you learn something new is a good day! Clyde