I want to make a tabular report in which each current record is compared with the next record. If the first field is equal, I want to suppress that next record, but concatenate each of the fields, starting with the second field, of the next record with the corresponding field of the current record. The result will be a little bit like the effect of grouping on the first field, but without the vertical offset of the remainder of each line. It also means that with a box outline for each field, the entries for every record in that group will appear in the same "cell". Trouble is, I have no idea how to go about coding it. I assume I have to start with code opening the query, and then some kind of loop. Don't know how to specify fields or whether I have to declare variables for current record and next record. If anyone can give me some pointers, I'll be very grateful.
(Using Access97)
Thanks
John
(Using Access97)
Thanks
John
