G
Gary K
I'm getting some very strange results from a query I'm running. I've boiled
it down to a problem when using a Group By query when joining tables on two
or more columns. In that case, one of the fields is showing some Asian
character set (Korean, I think) in the result. In viewing the table
directly, or querying with only one joined column or no Group By, the normal
English values show.
Here is the query that returns Korean in the Description field (note: this
is a scaled-down query just to demo the problem):
SELECT Tasks.Description, Max(Tasks.InitialLOE) AS MaxOfInitialLOE
FROM Tasks INNER JOIN [Time] ON (Tasks.Project = Time.[Dev Project]) AND
(Tasks.SummaryTask = Time.[Dev Summary Task])
GROUP BY Tasks.Description;
This query works fine:
SELECT Tasks.Description, Max(Tasks.InitialLOE) AS MaxOfInitialLOE
FROM Tasks INNER JOIN [Time] ON Tasks.Project = Time.[Dev Project]
GROUP BY Tasks.Description;
As does this one:
SELECT Tasks.Description, Tasks.InitialLOE
FROM Tasks INNER JOIN [Time] ON (Tasks.SummaryTask = Time.[Dev Summary
Task]) AND (Tasks.Project = Time.[Dev Project]);
Any suggestions are most appreciated!
Thanks,
Gary
it down to a problem when using a Group By query when joining tables on two
or more columns. In that case, one of the fields is showing some Asian
character set (Korean, I think) in the result. In viewing the table
directly, or querying with only one joined column or no Group By, the normal
English values show.
Here is the query that returns Korean in the Description field (note: this
is a scaled-down query just to demo the problem):
SELECT Tasks.Description, Max(Tasks.InitialLOE) AS MaxOfInitialLOE
FROM Tasks INNER JOIN [Time] ON (Tasks.Project = Time.[Dev Project]) AND
(Tasks.SummaryTask = Time.[Dev Summary Task])
GROUP BY Tasks.Description;
This query works fine:
SELECT Tasks.Description, Max(Tasks.InitialLOE) AS MaxOfInitialLOE
FROM Tasks INNER JOIN [Time] ON Tasks.Project = Time.[Dev Project]
GROUP BY Tasks.Description;
As does this one:
SELECT Tasks.Description, Tasks.InitialLOE
FROM Tasks INNER JOIN [Time] ON (Tasks.SummaryTask = Time.[Dev Summary
Task]) AND (Tasks.Project = Time.[Dev Project]);
Any suggestions are most appreciated!
Thanks,
Gary