Access går ned når jeg kører forespørgsel

is the data in linked tables in an Excel file? Try importinmg into Access and try there

Or are you tryin to make a query from Excel against an Access dB?

Have you tried repairing your Access dB?

Dataen er i en access database, som ikke fejler noget (hvis jeg fjerner where delen, virker forespørgslen fint).

Begge programversioner er 2003 med SP2.

I'm not happy with this in your JOIN

AND testing].[test platform] IN ('report','status')
)

If you move thsi to the where, does this help?

Den del skal være i min JOIN.. Der skal kun tages Comment fra de rows med test platform = report/status.

Synes det er en lidt problematisk måde, access håndterer min query..

En anden løsning er self. at lave en UNION (som nedenfor) i stedet, men hader bare lange forespørgsler, der gentager sig næsten identisk :(..

SELECT
  [testing].*,
  NULL AS [comment],
  NULL AS [comment_date],
  NULL AS [comment_user]
FROM
  [testing]
WHERE
  [testing].[status] NOT IN ('closed','cancelled') AND
  [testing].[test platform] NOT IN ('report','status')

UNION

SELECT
  [testing].*,
  [comment].[comment] AS [comment],
  [comment].[date] AS [comment_date],
  [comment].[user] AS [comment_user]
FROM [testing] LEFT JOIN [comment] ON (
  [testing].[id] = [comment].[referid]
)
WHERE
  [testing].[status] NOT IN ('closed','cancelled') AND
  [testing].[test platform] IN ('report','status')

Hmm. kom til at tænke på, jeg jo bare kan sætte comment til NULL, hvis test platform ikke er status/cancelled og bruge distinct til at sortere ikke-report/status comments væk:

SELECT DISTINCT
  [testing].*,
  IIF([testing].[test platform] IN ('status','report'),[comment].[comment],NULL) AS [comment],
  IIF([testing].[test platform] IN ('status','report'),[comment].[date],NULL) AS [comment_date],
  IIF([testing].[test platform] IN ('status','report'),[comment].[user],NULL) AS [comment_user]
FROM [testing] LEFT JOIN [comment] ON (
  [testing].[id] = [comment].[referid]
)
WHERE
  [testing].[status] NOT IN ('closed','cancelled')

Jeg lader mit spørgsmål stå åbent, hvis der er nogen, der har et svar/en forklaring på, hvorfor min original query ikke virker..

/1.

Lukker..