Hello all,

I am new to this community and looking for help on some formulas

I have three tables that I am trying to report off of.

Part Master Table

{Part_Master.PRTNUM_01} KEY

{Part_Master.RECVEN_01}

{Part_Master.COST_01}

NOTE: PRTNUM are equal in all 3 Tables.  VENID (2 Tables) and RECVEN (1 Table) are all equal

PO Receipts Table

{PO_Receipts.PRTNUM_55} Appears more than once

{PO_Receipts.VENID_55}

{PO_Receipts.INVCST_55}

{PO_Receipts.TNXDTE_55}

Part Vendor Table

{Part_Vendor.PRTNUM_07} Appears more than once

{Part_Vendor.VENID_07}

{Part_Vendor.BREAK1_07}

{Part_Vendor.COST1_07}

{Part_Vendor.BREAK2_07}

{Part_Vendor.COST2_07}

{Part_Vendor.BREAK3_07}

{Part_Vendor.COST3_07}

I am having issues with the formula to get:

MAX {PO_Receipts.INVCST_55} from {PO_Receipts.TNXDTE_55}

(currentdate – (currentdate – 365)) where {Part_Master.PRTNUM_01} = {PO_Receipts.PRTNUM_55} and {Part_Master.RECVEN_01} = {PO_Receipts.VENID_55}

Then the next formula is for each of the {Part_Vendor.BREAK1_07} (2 and 3)

I only want to show the record where {PO_Receipts.VENID_55} = {Part_Vendor.VENID_07}  For this I had (if {Part_Master.RECVEN_01} = {Part_Vendor.VENID_07} then {Part_Vendor.BREAK1_07}) but it shows every record each time the part number is found in the Part Vendor table.  I only what it to show once. and print the record that matches (PRTNUM and VENID)

Any help would be greatly appreciated.  Thanks in advance!