Search results

Hi Cosmos and Mile! Let's see. I am going to store each advocate in a table for advocates. We have about 40 advocate names. There's actually no duplication of advocate lastnames (if we were to get both a Joe Schmo and a Rob Schmo, we'd just add the initial to each name.) But the advocate table...

Hi Cosmos, Yes, we only have one or two for each case. (90% of the time, it's just one advocate.) So I don't think we need to create a table with the many-to-many relationship. Should I start trying to separate them once they're in Access? would it be best to try an sql statement, or work on the...

Hi Cosmos! Thanks for your help. I actually decided to combine Advocate1 and Advocate2 columns, into one "advocate" table once the info gets into access. (It's to follow those normalization rules.) What would be the best way: separate the advocate columns while they're in access, or while...

Hi Jack, That makes so much sense!!! I just have two more questions about implementing this solution: 1) How should I combine the old and new tables? I'm working with mockups right now. I tried to do a make-table query from the union query that I used to list the Old cases above the New cases...

Posted in utteraccess Hi, I plan to import an Excel spreadsheet that is not normalized. The Excel sheet has a column for Advocates. A client can have either one or two advocates. If a client has two advocates, they are both listed in the same column. The names are separated by a slash, like...

Good question, Jack. Let's see if this is reasonable: We have 9000 cases. All cases from roughly #4000-#9000 are in an Excel database. For old cases, we have about 4000 paper files, and nothing on the computer. The old cases are completed. We need to add each record in one fell swoop. For the...

hmmm...that's a good idea, but only kind of what I was looking for. thank you so much for all your attention...I am thinking that what my boss suggested doesn't exist in access. ; ) I'll try for two subform boxes: one subform to hold the set of cases with different fields, and one subform to...

OK...I read the tutorial and looked for more online. I tried making a query for the three tables. It has each of the different fields for each of the tables I'm manipulating. Then I went to make a subform. Problem is, I want each of the three subforms to pop up as separate entities WITHIN the...

looks good...is there also a tutorial that would help me build the type of query I want? thanks again!!! sarajini

Okay...I'm going to focus on adding subforms. I am in Form View. How do I get there to be multiple forms? I want the forms from three tables (two have the same fields, one does not) to pop up in the same subform box on the main form. Can I make all three tables pop up in the same box? (I want...

Hi Jack and thanks! You guys are really friendly! I think I'll keep it all in the Second normalization level. I have one ClientID, so I have a one-to-many relationship. I will connect all the cases to that one ClientID. Yes, there will be lots of duplication of entering for fields like...

how do you "normalize" tables? Hi Jack, What does it mean to "normalize" tables? I think I would like a "master" table for the client name and important info. Why do I want a separate table for Cases? Because a client can have more than one case, and cases can be of three different types. So...

Hi All, I am a brand new Access user. I would like to create some kind of security mechanism to protect certain fields from getting changed. First of all, I would want the entire database to be readable to everyone in our office. And I would want all users to be able to change data in fields...

Hi All, I am a brand new Access user, and I have a rather complex project. How do I use Access to pick out records that fall between certain dates? Please excuse my lack of knowledge about Access terms. I work in a law office. We have many cases that have an open date and, when we finish them...