Board index » Visual Basic/VB

All times are UTC



 comparing field values from two different access databases 
Author Message
Jame
#1 / 2
 comparing field values from two different access databases

VB Program  ------>Access Table 1 & Access Table 2

I need to compare one field from the table 1 with one field in table 2.
This is going to be a program that is reused with different tables on a day
to day bases.

Thanks,
James



Tue, 05 Aug 2003 23:19:16 GMT  
Steve Trac
#2 / 2
 comparing field values from two different access databases

select * from table1,table2 where table1.field1= table2.field1


Quote:
> VB Program  ------>Access Table 1 & Access Table 2

> I need to compare one field from the table 1 with one field in table 2.
> This is going to be a program that is reused with different tables on a
day
> to day bases.

> Thanks,
> James




Sat, 09 Aug 2003 05:55:27 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. select box should show values from two different fields from different tables

2. compare two fields values

3. Open Two Database with Two System.Mda and Two different User Names and Password

4. Comparing two data fields in Access through Visual Basic

5. Compare structures of two Access databases

6. Compare two access databases, size of tables

7. Comparing the subfolders in two different folders

8. Comparing values in a Access database

9. Trying to bind data from two different tables to two different controls

10. Comparing two values which may be Null

11. COMBOBOX.BOUNDTEXT VALUE CHANGES TO DIFFERENT FIELD VALUE

12. comparing two integer values don't work

  

 
Powered by phpBB® Forum Software