Search results

Thanks all! So - dumb question - do you use the "@" prefix to refer to usernames - or is that not used here?

Here's a possibility - maybe: Query 1 (qryTest1) written as such: SELECT T.[Partners Name] AS Partners, Max(T.[Comment Date]) AS Comment_Date FROM [Any Table] AS T GROUP BY T.[Partners Name]; With Query 2 written to use qryTest1 - to give your intended outcome: SELECT Q.Partners...

theDBguy is spot on... I will often do a dim strSQL as String, and then set that variable to the string that defines the query. You would then have ...OpenRecordset(strSQL) instead. I would then pause the code at that point, use the "View Immediate" screen, and type ?strSQL in it - to grab...

Thanks - looking forward to starting here (rather than Google) for my occasional Access questions... should be interesting.

I'm Papa_Bear1 and I'm just introducing myself to AccessWorld. I've been programming in Access since I can remember (... the early 90s... ;-) I think it is a fantastic realm to live in. I've been singing the praises of MS Access for many years. I do admit that having used it for so long, I...