Search results

As you suggested, I renamed by query to qryGetCurrentSession and it worked but I don't know why. I'm just starting building my queries and, so far, only have the two so I'm not sure what sort of conflict there could have been.

I have a query that gets the current session, named GetCurrentSession: SELECT MAX(Session.[SessionID]) as Sess FROM [Session]; This query works fine and returns the correct value. Then, I want to use it to get client purchases from only the current session: SELECT Purchases.PurchID...

Hi All, My name's Shane and I have been using Access and dbases on and off for a while but consider myself a newbie. I'm currently working on personal project converting a spreadsheet to a more manageable dbase. I enjoy camping, long walks on the beach, and forcing out a third item in a list...