ConcatRelated Issue (1 Viewer)

[larryl]

The database that I am attempting to make functional querys a table to find Sequence 0, then 1, and so on but I am unable to make it stop concatenating after it does Level 0.
It looks like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9

2
10029035-FA
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9

And should look like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9

2
10029035-FA
23058/1
1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9

Note that the SubPartsOps for Seq1 and Seq 2 are no longer concatenated. Anything beyond Seq 0 wants to concatenate everything. It works fine with where Job Numbers have only Seq 0 Part.
I am hopeful that someone much more knowledgeable can help me see my error. I am using Allen Brownes ConcatReleated module and it works great concatenating the first level of operations.
Thank you.

 

[Severin]

Is it possible for you to upload the db?~)

 

[larryl]

Thank you for reveiwing my database. Unfortunately I have not posted enough in the forum and the db is 17mb. If there is another way to get this to you or send you the link please let me know.
Respectfully,
Larry

 

[Severin]

When you use the concatenate module you need to add all the levels to the where clause in the call!~)

I believe in this instance you only got job number, you need to add seq.

 

[larryl]

Thank you so much Severin! The program works perfectly.
Larry