3 problems in access

[DORONKI11]

hello everyone,


i have few problems (access 2007).
1. i want to make a query that gives me the opposite from what im asking. i mean if i make a query from 2 connected tables - it'll give me (for example) the people that appear in both tables. i want the query to show the people that not appear in both tables - that appear only in one of them. how do i do that?

2. i want to make a form that has a button. when you click it, it opens the importing data wizard and then you can iport any excel document - but i want it to be automatic (that's why the button exist).

3. i want to import an excel table with two rows to an access table with many rows. the excel table contains one row that's the row with the primary key in the access table and another row with data. i want to update the data in the access table by importing the document to the access and then it changes the specific row i want to update. it knows what column to update by the first row of the document - with the primary key.


thank you very much guuuuuys!!!!!
you are great!

[alansidman]

Take a look at the attached for a solution to question 1. Not sure about 2 and 3. Need to re-examine.

[DORONKI11]

thank you, but can you explain me too what you did in this database??

and can anybody else answer me my other probs?

thank you very very much!

[alansidman]

Created two tables with names. Created a query to join the tables on names with a left join. In the criteria for the second table, filtered on Is Null. This provided me with the names of everyone in the first table and not in the second table. I then created a second query and joined the tables with a right join and then in the criteria of the first table, filtered on Is Null. The result then was everyone in the second table not in the first table. Hope this is clear.

This might be helpful also

http://www.databasedev.co.uk/comparing_records.html

Alan

[DORONKI11]

hey, people - can you please help me with my other problems??