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