Search results

David R, I have created the PK and FK tables and some queries, my trouble i, when I want to create a query that shows this, I cannot succeed: [Contact] [Phone 1] [Phone 1 Type] [Phone 2] [Phone 2 Type] Bob 555-1212 Home 666-1212 Work Amy 434-1212...

Thanks David. The FIRST command works when I concatenate the first and last name!! You've been a great help. I'm making good progress now...You're a great teacher!

David R - No problem on delay - I just appreciate all your help! I hope life is more sane for you soon! I have a new question for you regarding queries I've built. I have three tables, lets say they are: tblContacts Fields: AutonumConPKey FName LName Address tblInvestmentEntity Fields...

Thanks again for your help David. I appreciate your feedback and help! I feel good that I have the many-to-many thing set up!! Now I made some forms and would like your advise! I wanted to run the forms from a query I wrote so I could limit them to showing investors or prospective...

Okay WOW! This is a lot of stuff to learn! I'll be out of questions for a while to get this going. I'm building a test datbase to try this. But I want to be sure I'm on the right track. This is an example of my raw data in a spreadsheet layout...

Wow David. Thank you! I've just been sitting here thinking about this kind of structure change and I think I can do it! I'm excited to try. A number of questions. ************** First inexperienced and probably dumb question…when you add new records to these fields how do the...

David, First, thanks! I did read normalization but I am having a problem getting my head around how that would work. I really have to be honest and say I think it's beyond my comprehension!! Or I just haven't worked with a teacher who can help me with it. I think I should probably have the...

Hey thanks for having this forum-I've learned a ton already! But, I have a table 'Investors' with fourteen different fields containing the amount of money the investor put in a fund. These are displayed on an Investor Entry Form and summed. (The data is all one table.) The actual person or...