Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. proplyds

    Eliminate specific records in transactions

    Hi, Thank you all for your kind answers and sorry about confusions. Truly appreciate your time and patience. Got this solved by another senior member in our team, it was quite a bit more that I thought would be - as it happens. I can reproduce at a point in time what was done if may help...
  2. proplyds

    Eliminate specific records in transactions

    Hi Pete, hmmmm... it's a bit more complicated. the formula I described is used in a subreport which passes a variable to the main report showing all transactions considered as adjustments or other fees (many codes). The SYS2 and WA are not included in the formula (or in the many codes in the...
  3. proplyds

    Eliminate specific records in transactions

    Hi Pete, well, the data in table1.transaction is really a column showing transaction codes so they are in the format TR01....TR15 and some other codes, so basically when I have these codes I want to pull money amounts from table2.amount column. the formula the way I described it works however I...
  4. proplyds

    Eliminate specific records in transactions

    Hello, I have a little problem - not sure if it is trivial however can't seem to make it work. I have a simple formula: if {table1.transaction} in ['tra1', 'tra2', 'tra3', 'tra4', 'tra5] then {table2.amount} else 0 Now, I have another transaction - call it 'sometra' so what needs to happen is...

Part and Inventory Search

Back
Top