View Single Post
  #1   Report Post  
Lotus123
 
Posts: n/a
Default How do I group record w/same info but different number in a row

How do I group a record with same info but different number in a row.
Example below:
ID, lname, fname, dob, fallqty,
ID, lname, fname, dob, springqty

How do I write the code to put the column "springqty" on the same line with
the "fallqty" and group the rest of the info since they are all the same(ID,
lname, fname, dob)?