brucemc777
Member
- Local time
- Today, 06:12
- Joined
- Nov 1, 2012
- Messages
- 37
Thank you for considering my issue!
OK, i give-
Just starting back with Access after 13 years not using it, and a real bad memory-
We have a five field table named "tblOrderEquipment" (which was a lousy name as it suggests it is for equipment to be ordered, but instead it was meant to join information from a table with many orders on it to a table with many different items of equipment on it).
In the field "IDEquipment" we have one equipment item per record.
In the field "IDOrders" we have an identifier of a specific order.
Multiple records might have the same order number when that order had multiple items of equipment listed in afore cited field "IDEquipment".
For all the records with the same "IDOrder" i want a concatenated string of all the individual "IDEquipment" texts items associated with that "IDOrder" number.
I state ""IDEquipment" texts" because although a number is actually stored there, that field displays a brief equipment item textual description.
In the hopefully attached screenshot, if i wanted the list for "IDOrders" = 6, i would get a string that read "22" Monitor, Camera, 4K HD IR Night, NVR 4Channel, POE 4 Port". Now, if i really were dreaming, i could get the corresponding "UnitCount" field with the item description.
Thank you for your help, your expertise and your consideration!
-Bruce
I think that a function called "DConcat" is part of the solution, but that is simply from me trying to solve this myself for a day and getting a little too confused
OK, i give-
Just starting back with Access after 13 years not using it, and a real bad memory-
We have a five field table named "tblOrderEquipment" (which was a lousy name as it suggests it is for equipment to be ordered, but instead it was meant to join information from a table with many orders on it to a table with many different items of equipment on it).
In the field "IDEquipment" we have one equipment item per record.
In the field "IDOrders" we have an identifier of a specific order.
Multiple records might have the same order number when that order had multiple items of equipment listed in afore cited field "IDEquipment".
For all the records with the same "IDOrder" i want a concatenated string of all the individual "IDEquipment" texts items associated with that "IDOrder" number.
I state ""IDEquipment" texts" because although a number is actually stored there, that field displays a brief equipment item textual description.
In the hopefully attached screenshot, if i wanted the list for "IDOrders" = 6, i would get a string that read "22" Monitor, Camera, 4K HD IR Night, NVR 4Channel, POE 4 Port". Now, if i really were dreaming, i could get the corresponding "UnitCount" field with the item description.
Thank you for your help, your expertise and your consideration!
-Bruce
I think that a function called "DConcat" is part of the solution, but that is simply from me trying to solve this myself for a day and getting a little too confused