Search results

Great! glad to hear you got it working. Anthony

Joseph, Posting from my iPhone so can't open file. When you connect the two queries, connect by both TransferDate and PersonnelID, that will eliminate duplicates. You are almost there. Anthony

Did you try the two query approach? Create the first one like I said max of transfer date and group by PersonnelID. Run the query you should see the most recent transfer date for each PersonnelID with no duplicates. Create a query with the T_personneltransfers and the new query. Join the two...

Bob, That was exactly it - thank you so much! Anthony

thanks again, but I put in a break and looked at the recordset and it is indeed empty so never gets a chance to even get to the first assignment statement. I'm sure i'll have to fix the code to match yours once I get the query figured out. Here is my working query if run directly from Access...

Thank you, that got me past the syntax error, but the recordset is still coming back empty. I copied the text into a new query dropped all the code used for formatting and it returns the record I expect. Not sure what I'm doing wrong in code. It's pretty convoluted, but what I'm trying to get...

Hey Joseph, I'm sure there is a better way, but you could probably make two queries. The first would be off of T_personeltransfers Do an aggregate query with max of TransferDate, and group by PersonelID Then create a new query using the same table and first query. Connect the personelID and...

I'm haveing a tough time converting a query I created into a recordset. Here is my vba code: Public Function PriceLookup(PackagingPK As Integer, HarvestDate As Date) As Integer Dim dbs As Database Dim rsSQL As DAO.Recordset Dim strSQL As String Set dbs = CurrentDb strSQL = "SELECT...