Query Too Complex

  • Thread starter Thread starter James Gaylord via AccessMonster.com
  • Start date Start date
J

James Gaylord via AccessMonster.com

OK I have a simple Acc 2000 (or maybe not) select query based on 1 table.
There are 19 fields with 7 having Selection criteria on them something like
this "[Enter Table Name] or [Enter Table Name] is null". I save it and it
works fine for a while sometimes up to a month. Then all of the sudden I
will get a "Query is too Complex" message. I have not yet figured out what I
am doing in the query to cause this to happen. I am pasting the code below.
(Warning very long SQL statement) I have turned off the Name Auto Correct.
I compact everytime I close the database. As soon as I remove and then re-
add the selection criteria (not sure if this is the proper term) it works
fine again for a period of time. I do notice that this may happen if I hide
to unhide a field on the query. Can this cause the issue I am seeing?

TIA

Code
--------------------------------------------
SELECT [2000 Rules Table Detail].[Rules Table Name], [2000 Rules Table Detail]
.[Rules Table Type], [2000 Rules Table Detail].[Table Segment Value 1], [2000
Rules Table Detail].[Table Segment Value 2], [2000 Rules Table Detail].[Table
Segment Value 3], [2000 Rules Table Detail].[Table Segment Value 4], [2000
Rules Table Detail].[Table Segment Value 5], [2000 Rules Table Detail].[Table
Segment Value 6], [2000 Rules Table Detail].[Table Segment Value 7], [2000
Rules Table Detail].[Table Segment Value 8], [2000 Rules Table Detail].[Table
Segment Value 9], [2000 Rules Table Detail].[Table Segment Value 10], [2000
Rules Table Detail].[Bubble Sequence], [2000 Rules Table Detail].[Rules Table
Value], [2000 Rules Table Detail].[Entered Unit Price], [2000 Rules Table
Detail].[Item Number (Short)], [2000 Rules Table Detail].[Quantity Per],
[2000 Rules Table Detail].[Unit of Measure], [2000 Rules Table Detail].ID
FROM [2000 Rules Table Detail]
WHERE ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value])) OR (((
[2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Type]) Is Null)) OR ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=
[Enter Table Name]) AND (([2000 Rules Table Detail].[Table Segment Value 2])
Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null)) OR ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND
(([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null)) OR
((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null)) OR
((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail]
.[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter
Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table
Name]) AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table
Name]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null)) OR (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND (([Enter
Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]
) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type])
AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail]
.[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter
Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]
) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=
[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Type])=
[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 2])
Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].
[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table
Name]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND (([Enter
Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]
) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND ((([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table
Type]) AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble
Seq]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3])
Like [Enter Partial/Full Seg Value 3]) Is Null)) OR ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000
Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]
) AND (([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND (
(([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail]
.[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2])
Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND
(([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR ((([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([2000 Rules Table Detail]
.[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter
Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null)) OR
((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND ((
[2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND
(([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND ((
[Enter Table Type]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is
Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Rules Table Value]
) Like [Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null)
AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Type])
=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((
([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter Table Name])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null))
OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter Table Type])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null))
OR ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
(([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment
Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000
Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]
) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND (([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Type])
=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((
([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter Table Name])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null))
OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND (([Enter Table Type])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null))
OR ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND
(([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000
Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]
) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND (([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Type])
=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) AND ((([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((
([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) AND (([Enter Table Name]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq])
Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table
Name]) AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Rules Table Value]
) Like [Enter Partial/Full Table Value]) AND (([Enter Table Type]) Is Null)
AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3])
Like [Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((
([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND ((
[Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table
Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Value]
) Like [Enter Partial/Full Table Value]) AND (([Enter Table Type]) Is Null)
AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) AND
(([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter
Table Name]) AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Table Segment
Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is
Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND ((([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null))
OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is
Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble
Seq]) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].[Bubble Sequence])
=[Enter Bubble Seq]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is
Null)) OR ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is
Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=
[Enter Table Name]) AND (([2000 Rules Table Detail].[Rules Table Type])=
[Enter Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 3])
Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].
[Bubble Sequence])=[Enter Bubble Seq]) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Type])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) AND (([2000 Rules Table Detail].
[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is Null) AND
(([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble
Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000
Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble
Seq]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name])
Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table
Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null))
OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1])
AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules
Table Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND (([Enter Table Name])
Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules
Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000
Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Bubble Sequence])=[Enter Bubble Seq]) AND ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter
Table Type]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble
Seq]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter
Table Name]) AND (([2000 Rules Table Detail].[Bubble Sequence])=[Enter Bubble
Seq]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Bubble Sequence])=[Enter
Bubble Seq]) AND (([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is
Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value])
Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table
Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([Enter Bubble Seq]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Type])=[Enter
Table Type]) AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([Enter Table Name]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter
Table Name]) AND (([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([Enter Table Type]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND (((
[2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table
Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((
[Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND ((([2000 Rules Table Detail].[Table Segment Value 1]) Like
[Enter Partial/Full Seg Value 1]) Is Null) AND (([Enter Bubble Seq]) Is Null)
AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((
[Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([Enter Table Name]) Is Null) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (([Enter Bubble
Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null)
AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((
[Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) AND (([Enter Table Name]) Is Null) AND ((
[Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble
Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like
[Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].
[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table Detail].
[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2])
Like [Enter Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is
Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) AND (([Enter Table
Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg
Value 3]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter
Partial/Full Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) AND (([Enter Table Name]) Is Null)
AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND ((([2000 Rules Table Detail].[Table
Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND ((
[Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([2000 Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full
Seg Value 2]) AND (([Enter Table Name]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) AND (([Enter Table Type]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is
Null)) OR ((([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter
Partial/Full Seg Value 1]) AND (([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([Enter Table Name]) Is
Null) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND
(([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000 Rules Table
Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (
(([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq])
Is Null) AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Type])=[Enter Table Type]) AND (([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) AND (([Enter Table
Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 1])
Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg
Value 2]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value
2]) Like [Enter Partial/Full Seg Value 2]) AND (([Enter Table Name]) Is Null)
AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) AND ((([2000 Rules Table Detail].[Table Segment Value 2]) Like
[Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is Null) AND
(([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].[Rules Table
Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR ((([2000 Rules
Table Detail].[Rules Table Type])=[Enter Table Type]) AND (([2000 Rules Table
Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg Value 1]) AND (
([Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3])
Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name]) AND (([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].
[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND
((([2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter
Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((
([2000 Rules Table Detail].[Rules Table Value]) Like [Enter Partial/Full
Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Table Segment Value
1]) Like [Enter Partial/Full Seg Value 1]) AND (([Enter Table Name]) Is Null)
AND (([Enter Table Type]) Is Null) AND ((([2000 Rules Table Detail].[Table
Segment Value 2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 3]) Like [Enter Partial/Full
Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules
Table Detail].[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is
Null)) OR ((([2000 Rules Table Detail].[Rules Table Name])=[Enter Table Name])
AND (([2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND (
(([2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[2000 Rules Table Detail].[Rules Table Type])=[Enter Table Type]) AND ((
[Enter Table Name]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment
Value 1]) Like [Enter Partial/Full Seg Value 1]) Is Null) AND ((([2000 Rules
Table Detail].[Table Segment Value 2]) Like [Enter Partial/Full Seg Value 2])
Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 3]) Like
[Enter Partial/Full Seg Value 3]) Is Null) AND (([Enter Bubble Seq]) Is Null)
AND ((([2000 Rules Table Detail].[Rules Table Value]) Like [Enter
Partial/Full Table Value]) Is Null)) OR ((([2000 Rules Table Detail].[Rules
Table Name])=[Enter Table Name]) AND (([Enter Table Type]) Is Null) AND (((
[2000 Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full
Seg Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value
2]) Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null)) OR (((
[Enter Table Name]) Is Null) AND (([Enter Table Type]) Is Null) AND ((([2000
Rules Table Detail].[Table Segment Value 1]) Like [Enter Partial/Full Seg
Value 1]) Is Null) AND ((([2000 Rules Table Detail].[Table Segment Value 2])
Like [Enter Partial/Full Seg Value 2]) Is Null) AND ((([2000 Rules Table
Detail].[Table Segment Value 3]) Like [Enter Partial/Full Seg Value 3]) Is
Null) AND (([Enter Bubble Seq]) Is Null) AND ((([2000 Rules Table Detail].
[Rules Table Value]) Like [Enter Partial/Full Table Value]) Is Null))
ORDER BY [2000 Rules Table Detail].[Rules Table Name], [2000 Rules Table
Detail].[Table Segment Value 1], [2000 Rules Table Detail].[Table Segment
Value 2], [2000 Rules Table Detail].[Table Segment Value 3], [2000 Rules
Table Detail].[Bubble Sequence], [2000 Rules Table Detail].ID;
--------------------------------------------------

TIA

--
James B Gaylord
From the Wolf Comes the Strength of the Pack
From the Pack Comes the Strength of the Wolf
- R Kipling

Message posted via AccessMonster.com
 
Thanks for the response. Yes there is a reason behind the way the table is
set. This information actually gets imported into an AS400 JD Edwards
database. So this is the only way that the information could be handled at
the time. This is also a legacy from before I started, at some point I plan
on normalizing the data and creating a set of queries that will then pull
this back into an export file in the format need in JD Edwards.

I believe that my original idea of when I hide or unhide fields is the issue
here. I haven't had a chance to fully test it today, but I will and will
post back to let everyone know for future reference.

I will also look at the way I set up my criteria. I did post this in the
wrong area, it should have belonged in Queries, but I read another post just
before posting this and forgot to change to the queries newsgroup.
I will not attempt to assess the SQL in depth, but I will say I wonder a bit
about your database's structure when I see a succession of fields such as
[Table Segment Value 1], [Table Segment Value 2], etc. There may be a
legitimate reason for doing it this way rather than using related records,
but without knowing more about your database's purpose or structure I will
just say it seems questionable.
I don't know why the error appears. Sometimes if a query truly is too
complex you can use a sub-query, but I'm not sure I see a place for that
here. Another possibility is just that Access cannot make sense of
something in the query because of a type mismatch, for instance. Or the
report's Sorting and Grouping dialog could be creating a conflict.

One observation is that a criteria such as:
Like [Enter Partial/Full Seg Value 1]
should probably be:
Like "*" & [Enter Partial/Full Seg Value 1] & "*"
or
Like "*" & [Enter Partial/Full Seg Value 1]
or
Like [Enter Partial/Full Seg Value 1] & "*"
if you intend to use a partial field value as the criteria.

Since this is posted in Reports I would guess this query is the basis for a
report. In that case you may do better to use something like a multi-select
list box to filter the report. Allen Browne has a way of doing that here:
http://allenbrowne.com/ser-50.html
The technique can be adapted to build a SQL string that can be used as the
record source for a form or report.
OK I have a simple Acc 2000 (or maybe not) select query based on 1 table.
There are 19 fields with 7 having Selection criteria on them something
Click to expand...
[quoted text clipped - 1546 lines]
TIA
Click to expand...
Click to expand...

--
James B Gaylord
From the Wolf Comes the Strength of the Pack
From the Pack Comes the Strength of the Wolf
- R Kipling

Message posted via AccessMonster.com
 
Back
Top