Recent content by AnthonyE

  1. A

    Query to return only recent transfer data

    Great! glad to hear you got it working. Anthony
  2. A

    Query to return only recent transfer data

    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
  3. A

    Query to return only recent transfer data

    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...
  4. A

    Create recordset from SQL Issue

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

    Create recordset from SQL Issue

    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...
  6. A

    Create recordset from SQL Issue

    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...
  7. A

    Query to return only recent transfer data

    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...
  8. A

    Create recordset from SQL Issue

    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...
See more
Back
Top Bottom