Running query from Combobox (1 Viewer)

P

Pierre Beauchamp

New member

Local time

Yesterday, 19:59

Joined

Jul 22, 2010

Messages

6

• Apr 15, 2013

• #1

I created 2 combobox that list specific table in a data base. I want to create an unmatched query based on the selection from those two combobox.

All field in those table are the same.

 

boblarson

Smeghead

Local time

Yesterday, 17:59

Joined

Jan 12, 2001

Messages

32,059

• Apr 15, 2013

• #2

Pierre Beauchamp said:

I created 2 combobox that list specific table in a data base. I want to create an unmatched query based on the selection from those two combobox.

All field in those table are the same.

Click to expand...

Okay, your post is screaming out that this is not a normalized data structure. So the question is why is it not normalized? Why are there multiple tables with the same fields? This is not a proper relational database structure. So what is the purpose?

 

Last edited: Apr 15, 2013

P

Pierre Beauchamp

New member

Local time

Yesterday, 19:59

Joined

Jul 22, 2010

Messages

6

• Apr 16, 2013

• #3

The database in question is very big, every week we download files form different program like oracle and make this data base to combine all the data. The final process is one table. and we want to compare this table with old one.

 

boblarson

Smeghead

Local time

Yesterday, 17:59

Joined

Jan 12, 2001

Messages

32,059

• Apr 17, 2013

• #4

So, can you create (manually) one of the Unmatched Queries that you would want and then post the SQL here and then I can show you how to programatically change it to what you need.