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 Chris Miller 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: *

  1. stewarttn

    select count statement with parameters

    Mike, I changed the program to use running totals and that it working. Thanks for your help. T.N. Stewart
  2. stewarttn

    select count statement with selection parameters

    Thanks, Madawc. I changed the program to use running totals and it is working beautifully. Thanks again for your suggestion. T.N. Stewart
  3. stewarttn

    select count statement with parameters

    I did substitute the actual literals into one of the selects and that worked. The problem is that there are about 100 statements that I would have to modify each time. The academic year field is defined as varchar2(5) like 03-04. The block number is defined as varchar2(1) like 5.
  4. stewarttn

    select count statement with selection parameters

    Thanks for your help. I am using Crystal Reports 9. I think I will work with you running totals suggestion.
  5. stewarttn

    select count statement with selection parameters

    Could someone please look at this statement and see why my count is 0 when I know it actually is 1 ? SELECT COUNT(PRECEPTOR_SITE_EVAL."ENTHUSIASTIC") FROM "PRECEPTOR_SITE_EVAL" PRECEPTOR_SITE_EVAL WHERE PRECEPTOR_SITE_EVAL."ENTHUSIASTIC" = '3' AND...
  6. stewarttn

    select count statement with parameters

    Could someone please look at this statement and see why my count is 0 when I know it actually is 1 ? SELECT COUNT(PRECEPTOR_SITE_EVAL."ENTHUSIASTIC") FROM "PRECEPTOR_SITE_EVAL" PRECEPTOR_SITE_EVAL WHERE PRECEPTOR_SITE_EVAL."ENTHUSIASTIC" = '3' AND...

Part and Inventory Search

Back
Top