Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ssiroky

    Word field propagate

    I'm constructing a form templeate. I would like to know if it's possible to have a field on page one that would automatically fill a field on concurrent pages with the data placed in the first field. Is this an option in word and if so, how do I go about this? Thanks for any help
  2. ssiroky

    subtracting one formula from another

    ok, now I'm running into a larger problem. Each person's age creates a new record. So I'll have a victim of 5 years old, and an offender of 25. This will generate two separate records. So when I go to subtract the victim from the offender, I get these type of results. record 1 victim age =...
  3. ssiroky

    subtracting one formula from another

    thanks for the help Mike....that worked!!
  4. ssiroky

    subtracting one formula from another

    I created two formulas to designate victims' age vs. offender's age. for example, and I did the same for offenders if {INCIDENT_PEOPLE.ROLE_ROLE_TYPE} = "v" then ({INCIDENT_PEOPLE.APPROX_AGE}) else "" Now I thought that I could just take the new field "offenders" and subtract the new field...
  5. ssiroky

    QUERYING SAME FIELD, DIFFERENT VALUES

    I'm doing a search for records that have two values. For example. I want to grab all accidents (offense_code = "7000") and of those, I want all that also have an offense_code of "2450". I don't want only "7000", nor do I only want 2450's. Any ideas. THanks.
  6. ssiroky

    DATE FORMULA

    THANK YOU SO MUCH...THAT WORKED
  7. ssiroky

    DATE FORMULA

    I have a date format of {1/1/2004 12:00:00AM}. I'm currently using the formula: Year ({INCIDENTS.REPORT_DATE}) which gives me a numerical value ex. 2004 However, when I use this formula in another formula, it tells me I need to place a number here. Obviously I need to convert this value to a...
  8. ssiroky

    Converting short file names to long file names

    We have laptop computers with win98 onboard. A folders and files appear in the long filename format. However, when we load a CD containing a folder with file onto the laptop, only that folder with its files show up with short file names. This corrupts the files when used. I check the cd on...
  9. ssiroky

    reformatting a numerical value to group correctly

    I am trying to group ages of victims of crime. One group is 15 and under, the second is 16 and above. The 15 and under group is incidents.age <= "15". Because of the way the system looks at this particular field, any single digit over 1, is being grouped into the 16 and above category. I'm...
  10. ssiroky

    selecting out a value when multiples exist

    Unfortunately, I'm not familiar with shared variables. I know how to do a sub report, but from there, I'm not sure what to do. Any ideas?
  11. ssiroky

    selecting out a value when multiples exist

    I have a field {accident.causes} that I'm having some trouble with. I'm doing a count of accident causes for intersections. I have the intersections grouped and a count of accidents associated in the group footer. Now I need to do a count by {accident.causes} under each intersection. There...
  12. ssiroky

    creating a formula to do a count

    I tried to do the suggested ideas, but it's not working. First I have to form the groups, (i.e. Robbery, Murder). Then I need to do a count for each group by particular dates. For example, Aug. 2001 and Aug. 2002 to compare months. Is there any simpilier way to achieve this? I need it to...
  13. ssiroky

    creating a formula to do a count

    thanks for the help...I'll try the suggestions.
  14. ssiroky

    creating a formula to do a count

    I am trying to do a count of crime reports (incidents.inc_rep_number) by the crime offense (offense.offense_code). I have already created a group of offenses. Now I need to do a count for Aug. 2001, Aug. 2002, and Aug. 2003. The end result should look like this: Aug. 01 Aug...
  15. ssiroky

    null values

    thanks everyone for the help.....I got it to work :-)
  16. ssiroky

    null values

    I have two. One is a date field, the other is a string. If one is null, the other is null as well.
  17. ssiroky

    null values

    I'm running a report where one field has null values. If the value is null for this particular field, the record is thrown out. I need to be able to show all records whether they are null or not. I tried to make a formula to show null values as well as not null values: if isnull (field name)...

Part and Inventory Search

Back
Top