My question seems to be very easy, yet I am struggling in finding an answer. I have a table with the following information: First Name, Last Name and Group Number
#
First Name Last Name Group Number 1 Alex Bloom Group No.1 2 Peter Pan Group No.2 3 Jaime Flower Group No.2 4 Cat Boone Group No.1
I need to prepare a report in MS Access so that the data is grouped by number in two columns. For instance, it should like in the table as follows:
#.
First Name Last Name Group Number #
First Name Last Name Group Number 1 Alex Bloom Group No.1 1 Peter Pan Group No.2 2 Cat Boone Group No.1 2 Jaime Flower Group No.2
Anyone can give me an answer, pls?
Regards,
Dan.