Search results for query: *

Yes, table 1 and table 2 are linked by a Left Outer Equal Join. Could the linking be the problem? What link type do you suggest? Thanks, Grant

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...

Ok, you were right, I am getting unexpected rows. I am hammering away at it right now. I'll try to post again in a minute. Thanks a Ton, Grant

No, I am not getting any unexpected rows. I'm not sure I can integrate your solution into my report. I agree with the record inflation issue. Could changing the table joining possibly solve the problem? Thanks for the Insight, Grant

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...

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

Thanks, the solution in the whitepaper worked perfectly. I appreciate the immediate help as well. Rock on... Thanks, G

This is the message: "These documents contain subset fonts that have the same name and cannot be merged" I will agree that post didn't make too much sense. I am using Crystal 9.0 and Adobe 5.0. Hopefully here is a better example: I export 5 different reports from crystal into pdf format. I...

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...

When I remove the select expert criteria all of field1 records appear. The count running total (field2) displays the correct data but the sum running total(field3,not shown) is incorrect. The sum seems to be multiplied by the count runnning total(field4, not shown) next to it that is pulled...

I already have the linkning expert set to left outer join for the two tables. I placed my records in the details to determine if sorting was necessary. Is it possible to evaluate based on a field and use a formula when using a running total? Thanks, GIScrew

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...

I tryed some of the solutions but I am not too sure where to place the Nz function within the SQL statement. I am a beginner at SQL but I have a general understanding. Here is an example of my SQL for my Access query. For my current data the query returns null. But other data might generate...

Thanks everyone. I am attempting your solutions. I'll post my SQL in a day or so. Thanks, GIScrew

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...

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...

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

LB, I decided to put that report aside on friday and not touch it until today. I ran through all your suggestions and discovered my problem. I unsorted the records last week before I applied your suggestions for the running totals, instead of leaving the records sorted. Today, I sorted the...

I apologize; geo@one.net I've been out of it the last couple of days. GIScrew

Ok, here is my email: one@geo.net Make the subject; Attention Grant:Running totals Thanks, GIScrew