J
JAD
After running the following query a few times
I started getting an error "Query is too complex" .
Would you happen to know why this would work a few times, then get this error?
Thanks
SELECT [Table1].Region, [Table2].[IDNumber], [Table2].[InstallDate],
[Table2].[StartDate], [Table2].[StartDate], [Table2].[ EndDate],
[Table2].Place, [Table2].PM, [Table2].[Tech] FROM [Table2] INNER JOIN
[IDNumber] ON [Table2].[IDNumber] = [Table1].[IDNumber]
WHERE (([Table1].Region = [Forms]![SearchForm]![Region] OR
[Forms]![SearchForm]![Region] IS NULL)
AND ([Table2].[IDNumber] =[Forms]![SearchForm]![ IDNumber] OR
[Forms]![SearchForm]![ IDNumber] IS NULL)
AND ([Table2].[InstallDate]= [Forms]![SearchForm]![ InstallDate] OR
[Forms]![SearchForm]![ InstallDate] IS NULL)
AND ([Table2].[StartDate] = [Forms]![SearchForm]![StartDate] OR
[Forms]![SearchForm]![StartDate] IS NULL)
AND ([Table2].[EndDate] = [Forms]![SearchForm]![EndDate] OR
[Forms]![SearchForm]![EndDate] IS NULL)
AND ([Table2].[Place] = [Forms]![SearchForm]![ Place] OR
[Forms]![SearchForm]![ Place] IS NULL)
AND ([Table2].PM = [Forms]![SearchForm]![ PM] OR [Forms]![SearchForm]![ PM]
IS NULL)
AND ([Table2].Tech = [Forms]![SearchForm]![ Tech] & "*" OR
[Forms]![SearchForm]![ Tech] IS NULL));
I started getting an error "Query is too complex" .
Would you happen to know why this would work a few times, then get this error?
Thanks
SELECT [Table1].Region, [Table2].[IDNumber], [Table2].[InstallDate],
[Table2].[StartDate], [Table2].[StartDate], [Table2].[ EndDate],
[Table2].Place, [Table2].PM, [Table2].[Tech] FROM [Table2] INNER JOIN
[IDNumber] ON [Table2].[IDNumber] = [Table1].[IDNumber]
WHERE (([Table1].Region = [Forms]![SearchForm]![Region] OR
[Forms]![SearchForm]![Region] IS NULL)
AND ([Table2].[IDNumber] =[Forms]![SearchForm]![ IDNumber] OR
[Forms]![SearchForm]![ IDNumber] IS NULL)
AND ([Table2].[InstallDate]= [Forms]![SearchForm]![ InstallDate] OR
[Forms]![SearchForm]![ InstallDate] IS NULL)
AND ([Table2].[StartDate] = [Forms]![SearchForm]![StartDate] OR
[Forms]![SearchForm]![StartDate] IS NULL)
AND ([Table2].[EndDate] = [Forms]![SearchForm]![EndDate] OR
[Forms]![SearchForm]![EndDate] IS NULL)
AND ([Table2].[Place] = [Forms]![SearchForm]![ Place] OR
[Forms]![SearchForm]![ Place] IS NULL)
AND ([Table2].PM = [Forms]![SearchForm]![ PM] OR [Forms]![SearchForm]![ PM]
IS NULL)
AND ([Table2].Tech = [Forms]![SearchForm]![ Tech] & "*" OR
[Forms]![SearchForm]![ Tech] IS NULL));