Search results

Hello everybody, I have solved the problem. What was missing in the query was the column with unqique values (whis is necessery to make this function work) I used the unique values (document+rev nr) to make the outer join, but didnt select it to show in the results. In that case, the...

I have managed to create a column with unique key numbers (document+rev). But the update query still doesnt append the records which are not in "table B yet"

Yes exactly! note that table A have multiple doc nr, but different revision. Table B might already have a docnr with a revision which is present is TableA. Maybe my explanation isnt that clear:o

Doesnt work..It shows everything what I have in TableB what is related to table A.. I dont want the docnr's with corresponding rev numbers between table A and B in the results.. The SQL code looks like this now SELECT export_MR_nodoubles.Name, export_MR_nodoubles.Revision...

Hello everybody Im a newbie and I have a database Issue..I tried to find information to solve for days but I didnt manage to have good results. In access Im working with two tables, this is my setup tableA.documentnr tableA.revison tableB.documentnr tableB.revision Both tables are filled...

Hi there, Im a MS-ACCESS newbie. It is a very important tool for me for my work so. I am trying to now more about the functionalities, but sometimes I do need a little bit of help! :) I will look around to see if I can help other people myself :) Samantha:D