Query and DMax help

[hockeylvr]

I have a query which includes a query "Parts_List" and a table "BOM"

Query fields:
seq_no (Parts_List)
level (Parts_List)
seq_no (BOM)
level (BOM)
Parent Level: [BOM.level]-1

Parent_Sequence: DMax("[seq_no]","Parts_List","[Parts_List]![seq_no]< [Jupiter_LP2_BOM]![seq_no] AND [Parts_List]![level]=[Jupiter_LP2_BOM]![level]-1")

End_Sequence: DMin("[seq_no]","Parts_List","[Parts_List]![seq_no]>[Jupiter_LP2_BOM]![seq_no] AND [Parts_List]![level]=[Jupiter_LP2_BOM]![level]-1")-1

partno (Parts_List)

I am getting no data at all for the Parent_Sequence and End_Sequence and cannot figure out why?

Any ideas would be appreciated!

Thanks,

Toni

 

[PHV]

What is Jupiter_LP2_BOM ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hockeylvr]

Sorry - didn't change them all - was trying to keep it short!

Jupiter_LP2_BOM is BOM

Thanks

 

[PHV]

Perhaps this ?
Parent_Sequence: DMax("seq_no","Parts_List","seq_no<" & Jupiter_LP2_BOM.seq_no & " AND [level]=" & Jupiter_LP2_BOM.level-1)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hockeylvr]

Thanks PH! This looks like just what I need! I need to have my co-worker verify it and will post back with results.

Thanks again,

Toni