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 Chriss Miller 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. sopmac

    Another Multiple Lookups Problem

    Yes, i want to create a new table with the third field if the other two fields match. I am referring to only one table, this table contains my main data that I have retrieved from another database. Sure, there is data redundancy in this case; however, it is necessary for the application I am...
  2. sopmac

    Another Multiple Lookups Problem

    I have a table with three fields: territory, limit, and rate. What I need to do is lookup the first two fields from this table against my main table's "territory" and "limit" fields and then I want to return "rate" into a new table. Any help would be appreciated...
  3. sopmac

    Multiple Lookups Problem

    I am having problems with queries. I am trying to create a query that that refers to main data and then looks in a table for a specific figure. My table has fields for "symbol" and then several fields for "years" (2002, 2001, 2000,...). What I want to do with this table is...
  4. sopmac

    Excel and Access

    thanks for the reply, stew. well, i'd like to automate the process so that if a button is clicked the excel data will be shipped to the access database. i'm not too familiar with vb and macros, but am sure that it is the way to accomplish the task. thanks again in advance, Ivan
  5. sopmac

    Excel and Access

    Does anyone know of a macro that will allow me to send an excel 97 sheet to an access 97 database? Any help will be appreciated.
  6. sopmac

    Excel and Access Connectivity Problem

    Hello, I am having a problem connecting excel 97 and access 97. I am trying to create an excel spreadsheet that will calculate some figures. However, my data is in access and I am trying to automate my application so that it will read from access and display calculated results in excel. Or I...

Part and Inventory Search

Back
Top