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

 

[Pat Hartman]

Use a crosstab query.

 

[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

 

[Pat Hartman]

There is something wrong with the query. You'll need to post it. Open the query in design view and switch to SQL view. Copy the SQL string and post it here.