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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
query with Union ALL
Hi, When I do a search, I would like my form to show all the projects that a person is assigned to + Projects that he/she Performed By. Below is what I have; however, it does not give me any record. SQLquery = SQLquery & "tblEmployees.LastName " SQLquery = SQLquery & " ((FROM (tblProjects...- ThaoVy
- Thread
- Replies: 13
- Forum: Microsoft: Access Forms
-
Records display multiple times
Hello, I have a tblProjects where each Project# is entered once. I also have a tblProjectBusinessTypes where Project# is entered multiple times with different BusinessType i.e. Consulting, Product Demos, or Training and etc. I am using CR 10 and on the report, under the detail section, it...- ThaoVy
- Thread
- Replies: 6
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Problem with grouping not sum up correctly
Hello, I am using CR V 10. Below is my formulas: LastUpdate: Maximum ({tblStatus.EnteredDate},{tblStatus.ProjectNum}) DaysLastUpdate: DateDiff ("D",{@LastUpdate} , CurrentDate)- (DateDiff ("WW",{@LastUpdate} , CurrentDate)*2 ) LastUpdate (%): If {@DaysLastUpdate} <= 3 Then "100%" Else...- ThaoVy
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
SQL Expression: IsNull Function
Hello, Below is my SQL Expression: (SELECT Sum ("tblProjectBusinessTypes"."Cost") FROM tblProjectBusinessTypes WHERE "tblProjectBusinessTypes"."ProjectNum" = "tblProjects"."ProjectNum") However, I only want to pull those with no CompDate and no Cancelled Date. CompDate: If IsNull...- ThaoVy
- Thread
- Replies: 2
- Forum: Business Objects: Crystal Reports 4 Other topics
