How do I combine records

[Guest]

I have a table with the following fields:
Date
Equip#
Point#
Data

There are several points on each piece of equipment, and several pieces of
equipment that are documented each day, so that the table looks somthing like
this:

Date Equip Point Data

Date1 Equip1 Point1 Data1
Date1 Equip1 Point2 Data2
Date1 Equip1 Point3 Data3
Date1 Equip2 Point1 Data4
Date1 Equip2 Point2 Data5
Date1 Equip2 Point3 Data6
Date2 Equip1 Point1 Data7
....

I would like to create a list from that table which will show each reading
for the equipment on a given day. For example:

Date Equip Point1 Point2 Point3

Date1 Equip1 Data1 Data2 Data3
Date1 Equip2 Data4 Data5 Data6
Date1 Equip3 Data7 Data8 Data9
Date2 Equip1 Data10 Data11 Data12

I can create a query for any single point, but am not able to combine points
onto a single record. Any suggestions?

 

[Guest]

I think I figured out the answer using a crosstab query...