SELECT [All Info Table Query].Employee, [All Info Table Query].Title, [All
Info Table Query].[W/E], [All Info Table Query].Date, [All Info Table
Query].[Job #], [All Info Table Query].[Job Name], [All Info Table
Query_Crosstab ST].[Total Of Straight Time], [All Info Table Query_Crosstab
ST].[4/27/2009] AS [All Info Table Query_Crosstab ST_4/27/2009], [All Info
Table Query_Crosstab ST].[4/28/2009] AS [All Info Table Query_Crosstab
ST_4/28/2009], [All Info Table Query_Crosstab ST].[4/29/2009] AS [All Info
Table Query_Crosstab ST_4/29/2009], [All Info Table Query_Crosstab OT].[Total
Of Overtime], [All Info Table Query_Crosstab OT].[4/27/2009] AS [All Info
Table Query_Crosstab OT_4/27/2009], [All Info Table Query_Crosstab
OT].[4/28/2009] AS [All Info Table Query_Crosstab OT_4/28/2009], [All Info
Table Query_Crosstab OT].[4/29/2009] AS [All Info Table Query_Crosstab
OT_4/29/2009], [All Info Table Query_Crosstab DT].[Total Of Double Time],
[All Info Table Query_Crosstab DT].[4/27/2009] AS [All Info Table
Query_Crosstab DT_4/27/2009], [All Info Table Query_Crosstab DT].[4/28/2009]
AS [All Info Table Query_Crosstab DT_4/28/2009], [All Info Table
Query_Crosstab DT].[4/29/2009] AS [All Info Table Query_Crosstab DT_4/29/2009]
FROM [All Info Table Query_Crosstab DT] INNER JOIN ([All Info Table
Query_Crosstab OT] INNER JOIN ([All Info Table Query_Crosstab ST] INNER JOIN
([All Info Table Query] INNER JOIN [Employee Listing] ON [All Info Table
Query].Employee = [Employee Listing].Employee) ON [All Info Table
Query_Crosstab ST].Employee = [Employee Listing].Employee) ON [All Info Table
Query_Crosstab OT].Employee = [Employee Listing].Employee) ON [All Info Table
Query_Crosstab DT].Employee = [Employee Listing].Employee;
KARL DEWEY said:
Post the SQL of your crosstab query.