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 strongm 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. KingPhoenix

    Link 2 databases and suppress records if exist in both

    Hi all, Ok, i have an issue that i cant get my head around. I have a report which exports a CSV file, to allow a SQL DTS to import automatically into another database. What i need in the report, is for it to check the new database, and if it already exists in there to suppress the record...
  2. KingPhoenix

    Linking 3 SQL Tables

    Running CR XI - SQL 2000 Im linking 3 tables together... QM / QP / QR I need to get the furthest most quantity value. So im looking at QM (the master record set) to get a list of job numbers (displayed on report) im then running an if statement to check the QR table, and if the value is above...
  3. KingPhoenix

    Getting difference between 2 group summarys

    Hi... System - CRXI I have a group sort in place, stock transaction, it identifies whether the stock came in or out. I have a summary in the group footer showing the total qty. What i now need to do is Stock in - Stock out to show the difference... (i.e. did we order too much in) But i cant...
  4. KingPhoenix

    ehlo / helo - How do i change?

    Currently running BOXI, our e-mail server has been changed, and i need to change the e-mail commands from BO... I remember seeing the setting, but cant find it anywhere anymore..... Thanks in advance

Part and Inventory Search

Back
Top