Aug 11, 2007 #1 tattoo911 Programmer Mar 9, 2007 2 CA CreditToMinus([tbl_tx_Invoice_Header]![TRXType],[tbl_tx_Invoice_Detail]![Quantity]) AS Quantity thanks tattoo911
CreditToMinus([tbl_tx_Invoice_Header]![TRXType],[tbl_tx_Invoice_Detail]![Quantity]) AS Quantity thanks tattoo911
Aug 11, 2007 1 #2 PHV MIS Nov 8, 2002 53,708 FR Seems more like SQL than VBA ... Call a function named CreditToMinus with 2 fields value and name the resulting column Quantity. Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Seems more like SQL than VBA ... Call a function named CreditToMinus with 2 fields value and name the resulting column Quantity. Hope This Helps, PH. FAQ219-2884 FAQ181-2886