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 dencom 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: anglophobe
  • Content: Threads
  • Order by date
  1. anglophobe

    Suppressing group header based upon summarized footer

    I need to suppress a group header based upon a summarized value in the group footer. My set up is like this: GH1: CreatedDateTime Details ID# @Time_In_Status @SumTimeToEnd GF1: @Ave_Time_In_Status_Week the Time_In_Status formula gives a simple number value. The SumTimeToEnd...
  2. anglophobe

    Date difference between rows

    I need to find the date difference between two different rows of data. MY data is set up like this: ID# Old New Date 101 A B 15/01/01 101 B C 16/01/01 102 A B 17/01/01 103 B C 17/01/01 And I would need to find the difference between the...
  3. anglophobe

    left join with where problem

    I am trying to join several tables through inner and left joins. Problem: Prob# Type Date 01 KE Jan 01 02 P Jan 05 Incident Inc# Date Plink 01 Jan 03 01 02 Jan 07 01 03 Jan 11 02 Audit Parent_Link FN 01 TypeOfProblem 01 Status 02 Status What I need to end up with is: Prob# Type PDate FN...
  4. anglophobe

    Multiple left join error on CR10

    When I attempt to join three tables through left joins, I'm getting a syntax error of: Query Engine Error: 'DAO Error Code: 0xc03 Source: DAO.Database Description: Syntax error (missing operator) in query expression 'dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID LEFT JOIN dbo_Profile...
  5. anglophobe

    multiple left joins CR10

    When I attempt to join three tables through left joins, I'm getting a syntax error of: Query Engine Error: 'DAO Error Code: 0xc03 Source: DAO.Database Description: Syntax error (missing operator) in query expression 'dbo_Incident.RecID = dbo_AuditHistory.ParentLink_RecID LEFT JOIN dbo_Profile...

Part and Inventory Search

Back
Top