Search results for query: *

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

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

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

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

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.

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