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!

Recent content by dphilli1

  1. dphilli1

    Using Hyperlink to subreport from main report in CE8

    I am attempting to Hyperlink to a subreport from a main report. We’ll be doing some nesting of these subreports, which is why we’re not using the ‘subreport’ functionality already in Crystal 9 Report and Crystal Enterprise 8. After several contacts with the Crystal Helpdesk I thought I’d give...
  2. dphilli1

    Use of multiple "AND" statements

    After a little data validation Angel's method definitely works. I spent quite a while trying to figure this out this morning - thanks again. DP
  3. dphilli1

    Use of multiple "AND" statements

    Thanks for all your help folks!!!! Your suggestions are GREATLY appreciated. Angel seems to have it right with AND NOT, I'll need to perform some additional validation to be sure. Thanks again, DP
  4. dphilli1

    Use of multiple "AND" statements

    I'm brand spanking new at SQL - tutorials, internet searches, and the help menu aren't helping me with this. Here's my code: select distinct GLD_COMPANY,GLD_FISCAL_YEAR,GLD_FISCAL_PERIOD, acc_acct, acc_sub_acct_level01,GLD_ACCT_KEY,GLD_AMOUNT from DW_GL_TRANSACTIONS inner join dw_gl_account...
See more

Part and Inventory Search

Back
Top