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!

Register Log in
  • Congratulations Rhinorhino 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: GIScrew
  • Content: Threads
  • Order by date
  1. GIScrew

    Unexpected running total changes...

    I have running totals that generate weighted averages for 3 different fields in the report footer. The weighted averages come from a static table, table 1. Table 2 data changes every month or so. Table 2 has no influence over table 1 yet when I change the datasource for table 2, the weighted...
  2. GIScrew

    Running total problems....

    Report Description: My report consists of three tables. The tables are linked by a Left Outer join with an = Link Type. The report has 3 groups; State, County, Tract. There are 3 running totals; RT1 = DistinctCount(Eval on formula, reset based on group), RT2 = Sum(Eval on formula, reset based...
  3. GIScrew

    Right/Left Function...

    I am looking to take the Right(string,2) of a field. In Access, is this function performed in a query? Its been a long time since I have performed this function. Will someone refresh my memory on where to apply the necessary function phrase. Any guidance would help. Thanks, GG
  4. GIScrew

    Export Difficulties...

    My problem is regarding subset fonts within an exported document out of Crystal. I receive an error message from Adobe. The message, "These documents have the same subset fonts that have the same name and cannot be merged. This message appears after I attempt to insert a crystal report pdf...
  5. GIScrew

    Select Expert Problem...

    I am having trouble with select expert. I want all of my records in my key table to display even though the criteria of linked table loans.indate = "Y" is not met. For example I would like the followig results: field1 field2 A 23 B 10 C 0 D 45 E...
  6. GIScrew

    Null Values...

    I am having a small problem with a query that sometimes does not generate any data due to the criteria not being met. When I report this queried data I would like it to show up as a zero value instead of a null or blank query. Sometimes my data will satisfy the query criteria and other times...
  7. GIScrew

    Null Values...

    I am having diificulties with null values. When I change datasource locations for different report data, I run into a data display problem. If a query in access does not create any data for my report, none of the other data on the report populates like it should. If the field is left off of...
  8. GIScrew

    Possible to Chart Running Totals or Formula Fields?

    Is it possible to chart Running totals or formula fields? My chart is included in a sub report that is used to display percentages of loans. The formula fields are used to create the percentages. Is there another feasible way of creating the percentages instead of using formulas? Thanks, GIScrew
  9. GIScrew

    Running total problem...

    Thanks Ido and Brian, I am still having a problem. I should explain a few factors. I have 4 tables linked by a primary id, the census tract id number. My primary table is the assessment area table, most important, composed of 256 records, ie 256 census tracts for this assessment area, all...
  10. GIScrew

    Count problem...

    I need to count the number of bank loans per census tract id within a certain indate period. The indate field contains a "Y" for yes in date and " " for not indate. The unique id for each loan is a census tract id and there are multiple loans for each census tract id which...

Part and Inventory Search

Back
Top