Recent content by roi8877

My understanding of inner joins and what i've read is that it displays a subset of records only present on both sides of the table according to the fields they are joining on. So in my experiment, I have table A which has some duplicate records. I select disticnt on field1 and make a new table...

This works like a charm. :) Thank you very much. :) Now I have to drill this in my head. Important concept. :) Because easily many things stems for joins of all sorts....:) Thanks!

Hi, I have 2 tables A and B. A table has a field that is a combo box obtained from a query from another table say C. Table B is an import from excell and so I intend to populate table A with it. Im able to update other fields on table A but not this particular field that is a combo box...

Searched but to no avail to what appears should be a simple delete thing. I have 2 tables which I can easily create a select query, relate 3 columns together and view their records. Nice. Now change that to a delete query and run, I get the message "Specify the table containing the records...

Did you ever get this accomplished? I'm trying to do the same thing, only complication on my end is the table im importing too already has existing records..

I had followed the post http://www.access-programmers.co.uk/forums/showthread.php?p=849961 but im quiete concerned with the pk. I have a few related tables which they all branch off from a main table. Lets call it the top level table. Also the top level table already has records and it's pk...

Hmm, This is an interesting angle of attack in importing tables. I'm trying to do the same as thing as well. My only differece is, the top level table already has existing records and its primary key is random long interger. If I went ahead with this method, (to generate pk first using...