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!

Register Log in
  • 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. Anthracyda

    Efficiently querying a list?

    Thanks, but this illustrates my problem. Because there is no treaty between Brazil and Australia, I don't get a record for Brazil - NULL -15% - NULL
  2. Anthracyda

    Efficiently querying a list?

    I have 3 tables: Generic, Treaties, TreatyText simplified down to Table: Generic ID Country TaxRate -- ---------- 1 Brazil 15% 2 Australia 10% 3 US 5% Table: Treaties -- ---------- ID Payor Payee TaxRate 1 Brazil Australia 10% 2 Australia US 10% Table: TreatyText -- ----------...

Part and Inventory Search

Back
Top