Combine multiple records in single table form row?

[Guest]

I would like to know if it is possible to combine data from multiple records
(that share a key value) into a single row in table form. I have seen that
there is a concatenate function where I can string them all out with commas
but I would like to know whether there is any way to format the information
so that it appears as a table, so it is easier to look for missing values in
a column.

I have query results that look like:

EmpNum Employee PPEdate SumOfTotalHours
E00012345 ALLAN, GAYLE 10/14/2006 93
E00012345 ALLAN, GAYLE 10/28/2006 97
E00012345 ALLAN, GAYLE 11/11/2006 110
E00024680 ANDERSON, R 10/14/2006 80
E00024680 ANDERSON, R 11/11/2006 77.5

Notice, there is no entry for Anderson on 10/28. I would like to present
the data like this, so that it jumps out that time is missing for a pay
period:

EmpNum Employee 10/14/2006 10/28/2006
11/11/2006
E00012345 ALLAN, GAYLE 93 97
110
E00024680 ANDERSON, R 80
77.5

Is this possible without exporting to excel and manipulating manually?

Thanks for any help you can give me.

 

[Guest]

Wow. I didn't realize the wrap woud be for such a short line. You probably
have the idea, but here's a version of the desired output that fits on a
single line:


EmpNum Employee 10/14 10/28 11/11
E00012345 ALLAN, GAYLE 93 97 110
E00024680 ANDERSON, R 80 77.5

 

[Pat Hartman \(MVP\)]

Mushing the data into a single memo field will make what you want to do much
harder. Leaving it as it is, you can use queries to find rows with missing
values. You don't have to eyeball bunches of text.

If you want to display the data on a form or report, just use a
subform/subreport.