Use Query Pivot Table in Form

TimTDP

Registered User.
Local time
Today, 21:32
Joined
Oct 24, 2008
Messages
213
How can I create a pivot table in a query and use it in a form?
My date looks like this:
LoggerNumber DateTime Reading
33 12/10/2011 11:53:13 AM 3.9
34 12/10/2011 11:53:13 AM 3.1
35 12/10/2011 11:53:13 AM 3.8
33 12/10/2011 11:55:13 AM 3.9
34 12/10/2011 11:55:13 AM 3.1
35 12/10/2011 11:55:13 AM 3.7
33 12/10/2011 11:57:13 AM 3.8
34 12/10/2011 11:57:13 AM 3.1
35 12/10/2011 11:57:13 AM 3.7

and I want to display it in a form like this, when I open the form:
DateTime 33 34 35
12/10/2011 11:53:13 AM 3.9 3.1 3.8
12/10/2011 11:55:13 AM 3.9 3.1 3.7
12/10/2011 11:57:13 AM 3.8 3.1 3.7

I could use a crosstab query but I don't any agrigations (sum, min, max etc)
Please help, and thanks in advance
 

Users who are viewing this thread

Back
Top Bottom