Putting deifferent records into one record

[Purple_Heart]

HI there



I have build about 4 data basis so far as I am learning Access 2010, all on the same subject. Each time learning more.
At the moment I am stuck with a few problems bu lets try to sort them out one by one.

I have the following table with records (Just some of the data)

ID.. Animal...... Date............ Weight
1... AR001V.... 2012/02/16.... 400
2... AR002V.... 2012/02/16.... 370
3... AR003V.... 2012/02/16.... 430
4... AR002V.... 2012/03/11.... 380
5... AR003V.... 2012/03/11.... 440
6... AR001V.... 2012/04/22.... 405
7... AR002V.... 2012/04/22.... 385

I need to put the weights and dates of all the same "Animals" together like so:

ID... Animal... 2012/02/16... 2012/03/11... 2012/04/22
1.... AR001V.. 400................................. 405
2.... AR002V.. 370............. 380.............. 385
3.... AR003V.. 430............. 440

I have gotten this working with a cross-tab query but I then need to work on the results further which I can not do then. For instance I then need to work out the average of the weight for that day, and also the average of the animal over those days. Also of coarse the amount of dates and weights will increase every month or two

Have been trying everything the past three days and now need some outside help cause my brain in on information overload...

Thanks allot

[June7]

Use aggregate (GROUP BY) queries to generate statistical data.

Crosstab queries are dynamic in that the column outputs are continually changing. Stabilizing a crosstab so report will perpetually run is tricky.