Reports format

[Wesley Morgan]

I need to get information from a database that has data in rows and display the data in columns. Columns would be Date ; Time ; Data1 ; Data2 ; Data3 ; Data4 ; ect...

Data is now shown as Date ; TagIndex ; Values
Rows are date; index number ; data value

Example: have this now

Date Time TagIndex Val
08/03/2003 11:23am Data1 324
08/03/2003 11:23am Data2 32
08/03/2003 11:23am Data3 123

need this:
Date Time Data1 Data2 Data3
08/03/2003 11:23am 324 32 123
08/03/2003 12:23pm 323 36 119

Thank you

 

[Wesley Morgan]

I am new to the forum and still stumble into things as I go.
I have tried the crosstab query and had problems with the criteria in the Date and Time field. The date was formatted to short date and I had the criteria set to prompt the operator to input the date for the report.
In the select query, I had put: [Forms]![Report Date]![Date]
This was not perfect but it was a start.
In the crosstab query, the Date criteria was not allowed.
If I could get help on the date input the crosstab query will work.
Thank you,
Wesley Morgan

 

[Rich]

You have to define the query parameters as date/time

 

[Wesley Morgan]

When I define parameters in the crosstab query as Date/Time, the values in the other columns go crazy. Example: data would read as [ 457 ] is displayed as [ 355.002344657890 ] all values are effected except date and time. Can I set criteria in the field for the short date that would allow an operator to input a desired date for the report?
Thank you
Wesley Morgan

 

[Wesley Morgan]

I have the crosstab query working. Now I need to place data in single row for the time field. I am getting each field of data in a seperate row and column
Example:

Date Time Data1 Data2 Data3
08/17/2003 10:20am 345
08/17/2003 10:20am 323
08/17/2003 10:20am 215
08/17/2003 11:20am 345
08/17/2003 11:20am 323
08/17/2003 11:20am 215

I need:

Date Time Data1 Data2 Data3
08/17/2003 10:20am 345 323 215

08/17/2003 11:20am 345 323 215
Thank you