Just trying my luck- does anyone work with Microsoft Access Databases?

Parent Cafe
1

<p>In my other life, when I’m not on CC, I sometimes have to work with Databases. I’m now trying to combine lots of different tables in an Access Database but when I try to get rid of duplicates I lose too much data. Any experts out there who can help me out. I am using Access 97 and going crazy.
Thanks</p>

2

<p>OK - I know Access but I’m confused about what your problem is. I assume that the first thing you did was merge several tables. What are you doing to “get rid” of duplicates? I assume that you are trying to purge out identical records – but when you say you lose too much data, I’m confused about what you think you need to keep and what you think you might lose.</p>

3

<p>thanks calmom. I think my question goes back to my basic lack of knowledge about using access. Instead of using the field names for my tables I have a terrible habit of recreating the tables each time. I’m almost embarrased to admit that I don’t understand how to join the tables. I do the “join” but then I’m stuck. Any suggestions?</p>

4

<p>I don’t think this forum is very conducive to computer tech support. The only way I can help someone is for me to have my computer open at the same time the other person is working, and then lead them through step by step. I suppose that if you get really stuck, I can PM you with my AIM screen name so we can do a live chat, tech support session. But now is not a good time for me… I’m trying to enjoy a sunny afternoon & then I have plans for dinner out with my daughter, who rarely has time to fit me into her busy social schedule. :wink: </p>

<p>So in the mean time - I’m going to give you the links to some good online tutorials:
<a href=“http://www.ehow.com/how_13629_define-correct-join.html[/url]”>http://www.ehow.com/how_13629_define-correct-join.html&lt;/a&gt;&lt;/p&gt;

<p><a href=“http://cru.cahe.wsu.edu/training/Access97/[/url]”>http://cru.cahe.wsu.edu/training/Access97/&lt;/a&gt;&lt;/p&gt;

<p>You can Google for more, but be aware that there are enough changes between MS Access 97 and later changes that instructions in a tutorial may lead you astray – so be sure that anything you find is specifically for the version you are working with.</p>

5

<p>Thanks
Hope you enjoyed the beautiful day!</p>

6

<p>Did you get the answer to your problem?</p>

7

<p>NorthCoast-Thanks for asking. I sort of smushed a bunch of databases together and came up with something passable. Not ideal, but it works.</p>

8

<p>Thats all that counts, Good job!</p>