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 bkrike 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: *

  • Users: ssiroky
  • Content: Threads
  • Order by date
  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

    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...
  3. 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.
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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