Jump to content


  • Posts

  • Joined

  • Last visited

jess's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. FM8 Pro Trying to summarize precinct results for a particular race. Most records are listed as follows: Precinct# Rep Dem 2102 34 87 2103 56 98 2104 88 53 The above is what I want..but sometimes the data is as follows: Precinct Rep Dem 2103 55 50 2103a 25 15 2103bg 10 5 There really isn't too much of limit of the extension of the precinct. The sub precinct might be denoted with the letter "a" or "ab" or "bg" or "cde". Not a whole lot of ryhme or reason. How can I summarize each sub-precinct into a single precinct tally? So that the end result is: Precinct# Rep Dem 2103 90 70 2104 55 86 2105 45 21 Thx.. Jess
  2. Unfortunately, the Access database file has about 1.5 million records. MS-Excel tops out at 65,000.
  3. I've read that Filemaker does not support this file type and I should re-export my MDB file to something more FM friendly. However, I don't own a copy of MS-Access, so I can't re-export my file. Any ideas on how to convert a MDB file without owning a copy of MS-Access? thanx...
  4. Comment, Once again you pulled my rear end from the fire. Thanks for help.
  5. I have two files, one is really screwed up, and the other is in good shape. When I say screwed up, it lists voters with the wrong precinct, legislative district, senate district, and congressional district. Its literally like somebody threw all the voters into a hat and jumbled up thier information. What I would like to do is compare the correct voter file with the bad voter file and determine what percentage of the database is correct. The result will be something as simple as: Match = 85% The definite match in each file is address & city. What is questionable is the Precinct, Leg District, Senate District, and Congressional District. Also, both files are in FM8 format. I assume the first step is create a relationship between the files, but I'm fuzzy on which fields and ultimately getting percentage of successful match. An example dataset is below Address: 123 East Smith Street City: Yourville Precinct: 2397 LegDistrict: 22 SenDistrict: 7 CongDistrict: 3 Thanks in advance...
  6. Yes, it is some crazy scheme to inflate numbers..sort of. Actually, based on this group doing polling for us they have real problems identifying WHO is actually answering the questions. If they ask for a specific person on the phone they get something like a 2% penetration rate. Anyway..we are stuck making bold assumptions. Whoever answers the questions, then that is how the whole household will vote. I don't like that kind of thinking, but I don't make the decisions..just deal with the problems. So..based on Comment's response I've gotta figure out how to do the self-join and insert those responses to anyone with the same address. This should be fun.
  7. I've got a project going on where a company is contacting voters and getting responses. Unfortunately, they aren't determining who is answering the questions, just one of the voters living at a certain address. There will be other voters living at that address, but they didn't get a chance to answer the survey. I need to import thier responses (by matching ID) and apply thier responses to every other voter at that same address. Imagine that my contacts table looks like this: ID Name_First Name_last Address City Response1 Response2 Response3 Response4 The end result for me is that I have to export out those addresses where there are no no survey responses.
  8. I have some survey results for one person living at an address. And I have multiple people living at the same address. How could I apply the same survey results to all people living at the same address? thx...jess
  9. Never mind. I got it right with the portal.
  10. Comment, Thanks once again for the hand holding. I created a Questions table that includes: ID_Question Question Then I created a relationship from Voters Table to Responses Table (via ID_Voter) and another relationship from Responses Table to Questions Table (via ID_Question). How do I display all the questions asked that voter (with appropriate responses) on a single layout. I can't seem to figure it out with Portal but I can get one question and response to work as a related field. How do you get all the questions and responses to show up. FYI - I'm trying to place this in a tab control thingy in FM8.
  11. Comment, Is this what the Responses table should look like: ID_Answer ID_Voter Question Response
  12. What would be in the Subjects table?
  13. Not sure how to approach this one. A political candidate has been doing surveys over the last few months. In one district they asked one series of questions, in another district they asked another series of questions. Mostly the questions were same, but sometimes it 5 questions..and sometimes it was 7 questions. I looked at other posts on handle the situation and I'm not sure if I should set up two tables, one for questions and one for answers. Because I need to be able to show results on a per voter basis, I don't want to display/export a littany of questions that don't have a response for them. If anyone can get me started I would greatly appreciate it. I'm starting from scratch on this one... Jess
  14. Uhm..that was way too easy for you Lee. Thanks for sharing the brain once again. Jess
  15. I can't seem to make the find/replace script step appropriately. I want to remove both types of parenthesis and any dashes. I tried putting the three replaces into a loop, but either fails or it will only do the first script step. Any suggestions? I have 1.5 million records to clean up and would like remove those special characters in one shibang! Thanks.. Jess
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.