Compare Value between to tables

  • Thread starter Thread starter Sven Skudelski
  • Start date Start date
S

Sven Skudelski

Hi

I have 2 tables. with same field value. I like to check the value from one
field in the target with the value form the source table. I would like to do
this with recordset.

Regards
 
Far easier in a query by linking the 2 tables and using a third column to
compare a column from each of the 2. If you still want recordsets, you'll
need to build 2 recordsets, 1 for each table, then loop through the values
comparing them. Write the comparison to a table or a text file, or simply
use Debug.Print to view the results. You will need to order the recordsets
the same way to ensure the values correspond.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending records to new table using field names as values 2
Dlookup to compare two values? 0
How to Populate Data from a table to another 0
USING TABLE VALUE IN "BETWEEN...AND" EXPRESSION 5
How do I compare two tables? 1
Compare function values 5
Union and group, then count 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top