Recent content by Hasslehump

  1. H

    Return Combination of Records Based on Best Match With Additional Criteria

    Update: I think I'm nearly there but really struggling with the VBA code. Side note: I haven't done any coding since Hello World over 10 years ago so might be missing something very basic here, and apologies for any crappy formatting! It seems to me, the issue is that the "total" isn't being...
  2. H

    Return Combination of Records Based on Best Match With Additional Criteria

    That's great thank you! I did first create this in Excel so I can try to solve in that first then make it work in Access afterwards. I'll update if I solve this.
  3. H

    Return Combination of Records Based on Best Match With Additional Criteria

    Only a personal assignment! I'm not in any form of study at present. I'm essentially trying to create an auto-calculator for a parts list. I haven't tried anything other than searching the web so far, I'm completely stuck on idea's for this. I'm wondering if perhaps I'm out of my depth on this...
  4. H

    Return Combination of Records Based on Best Match With Additional Criteria

    I have a problem that I admit, I do not know where to even begin to resolve. My requirement is to return a combination of records that will fit when combined together as a closest match to the desired integer. I have records that have fixed values in the respective field containing the...
Top Bottom