Let say I have a database structure like below

 

ComputerID      HardriveID

123                     ABC

123                     DEF

123                     LKF

456                     DKE

 

So what that mean is that computerID 123 have 3 different hard-drive and computerID 456 have only 1 hard-drive.

 

What should I do so that when user run report on Computer123 it return all the HardriveID within one field? LIke this ( ABC, DEF, LKF) and only return DKE when user run report on computerID 456?

 

Thank you for your help