Recent content by tessie

Yes, I guess it would have to be a pretty big hat. :D

We do a draw every quarterly. We have about 1800 employees and what we do right now is print out the names and cut them out. Then we pick the name from a hat. Is there a way that access can do this so that we don't need to print and cut the names. Thanks for your help! :)

Hello, I have run the "Find Unmatched Query Wizard" and it found the records that are not on table A. But how do I add these unmatched record to Table A so that I do not have to use Table B. There are around 200 unmatched record that I need to merge to Table A. Thanks again for your help.

I have imported a table to an existing database. I want to merge two tables(A and B) together. I did an append query. What it is doing when I run this is that it is selecting records from both tables that have a matching value in the fields that are joined - I take this is called INNER JOIN...

I would like to just maintain one database and merge both tables together. I'm just not quite sure on how to do this. In answer to the above question from Pat: 1. Yes, this is a one time conversion. 2. There are some person that exist in both databases but I want to also merge the ones that...

Does my tables have to match in both database in order for me to link?

Hello, I have two database that I need to join together. These two database contains peoples names. What we are doing right now is if we don't find a person in one database eg. database "A" we would go into the other database "B" and look there. How do I combine both database together so that...

Thanks for your help Anthony. It works. :)

I have inserted an Excel file and PDF file in the design view of the form that I am working on by going through these steps: Insert-->object-->Create from file(I then went and browse for the file that I would like to insert)--->checked mark the link box and clicked ok My problem is that when...