Jump to content

Lougee

Members
  • Content Count

    115
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Lougee

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. I knew I could rewrite the calculation to account for the hyphen and prevent future problems. I did not realize that would 'reverse engineer' the incorrectly formatted records. So simple. Thank you.
  2. SSN field formatted to automatically insert hyphens in the correct places -- xxx-xx-xxxx -- so I don't have to stop twice in every entry to find that darned hyphen key. Works flawlessly. However, when someone else entered ID data, she typed in the hyphens so I have some records that, when formatted, look like xxx--x-xxxx. (The calculation is: Left (SSN; 3) & "-" & middle (SSN; 4; 2) & "-" & right (SSN; 4).) Is there someway I can see the original -- unformatted, just numbers -- SSN that I typed in?
  3. Am I wrong? OK, I understand now. The options dialogue when performing an import -- apply serial number, etc, gives me this option. I've NOT been doing this because I didn't want to break any calculations, serial numbers, relationships, etc. The calculated participation/person field doesn't have that problem. Which is the reasoning for using the calc. Thanks for bringing my misunderstanding to my attention. I'll go back and try it.
  4. I would if these records were always going to be created new in this table. But they might also be imported from several other files and auto-enter calculations don't work on imported records. Looks like I need to rethink this.
  5. Yes, and yes. If it's not, unique, the inputs aren't accepted. Some wort of dialog on the order of: your data doesn't generate a unique result. Please check your data and reenter. Or words to that effect. The point here is to be able to join a contact ID (one input) and a participation year (the other input) and generate a unique identifying 'participation year/person'.
  6. Is it possible to restrict the result of a standard (not auto-enter) calculation field to unique values only?
  7. I was exporting because the calculation that add up the total years of participation lives in the contactInformation table and counts ALL the years so I couldn't get totals up to a certain year and not after. But I could export only the relevant activeYear information. It feels like duplication of data, but now I also have a calc totaling active years in the activeYears table so a simple find should work for me. Thanks for the referral to the 'fast summary' example. It's way beyond what I would have been able to develop for myself; I never even thought of using variables. But it looks like it does exactly what I need. I'm having a great time playing with it and poking around under the hood.
  8. Exactly. The most recent year can be anywhere from 1988 to the present, and the parameters for selecting participants can vary with every search (i.e., all the females in years 2001-2003, or all the students in years 1999 and 2001 by gender). We are a grant-funded organization and must report to our funders on a quarterly basis. They let us know what they want reported and each grantor might ask for different demographic/participation information. This quarter, one of our funders is asking about total high school participants, by gender, by ethnicity, by longevity of participation. The find process is easy enough, but the summarization calcs are what I haven't been able to figure out. Actually, I have figured out half of the problem -- I can calculate the number of occurances for each ID. But I still can't summarize the number of unique IDs for each year.
  9. I need to extract information about our program participants from years gone by, without including any more recent information. I can select a program year -- say 2004/05 (school year) and find all the partipants that year and earlier (each year for each participant is a separate record in the AY_activeYears table). By exporting the contact_ID and activeYear of the found records of active years that fall into my range to a temporary FM file, I can eliminate any more recent information. Now I want to count how many of each contact_ID I have in my temporary file. That number equals the number of years each person has participated (longevity). For instance, I might have 7 records for contact_ID #1 which equals 7 years of participation or 2 records (or 2 years) for #21, etc. I want a calc/summary to give me the total years/records for each contact_ID. Then I need to summarize how many contact_IDs there are with each X number of years/records. It should be simple but I can't make it work. Please help. If I'm not clear (not unusual) I apologize.
  10. I want to create a 'dashboard' which will show the several most recent additions/changes across multiple tables. For example, I want to see a new contact added on 1/1 (contacts table), an agenda modified on 1/3 (event table), a participant who cancelled on 1/4 (registrations table) and a different contact whose address was changed on 1/7, assuming these are the 4 most recent additions/changes to the db. Can this be done and how might I approach it? As always, I very much appreciate your expert help.
  11. Basically the title says it all. I'm wondering if it's possible to create a value list whose values are the result of a calculation. For example, an event that begins on 1/1/2010 and ends on 1/5/2010... Is it possible to create a calculated field that would return a list of the dates (1/1, 1/2, 1/3, 1/4, 1/5) and could that list then be used as a value list for a drop down field? TIA
  12. Comment, Thanks for the suggestion. Guess I'm getting a little better at understanding how to approach these problems. I had just started to play around with the pop-up window for entering or editing attendance details, with just the results showing in the portal. I will post my end result. Or be back for more help, whichever comes first.
  13. Thanks much, comment. Working on it. I'll shout it to the world when I get it working! IS there any way to show multiple related records other than a portal? Something new or tricky or more knowledgeable than I am (I've so much still to learn..)
  14. Well, I've had a lot of fun, and learned a lot too, but I think I still need some more help. Inky Phil, your solution works -- I can enter data into either the top or the bottom field depending on the state of the chooser field. But even if I enter text into the bottom field, when I tab out, the top field remains on top. I need to figure out how to keep the field that corresponds to what was selected in the chooser field on top and visible. Any more suggestions, anybody? Abbe
×
×
  • Create New...

Important Information

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