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

    Summary by week starting Monday

    I want a chart that summarizes labor totals by week (no problem so far), but starting on Monday, not Sunday. When I group on Work_Date for each week, Crystal assumes the week starts with Sunday. How do I get weeks grouped Monday thru Sunday? CR 10 Access 2000
  2. begin2know

    Combining Update and Select in Crystal's SQL Command

    Ido and k~ Thank you each for your reply. Perhaps it is a limitation of the Access ODBC driver. I'll pursue other options for now. Regards ~stephe
  3. begin2know

    Combining Update and Select in Crystal's SQL Command

    I have tried everything that I can imagine. I even simplified matters by creating a test database with no security (thinking that might be part of the problem). My query is now... UPDATE "Customer" SET "Customer"."Contact" = '{?Name}' WHERE "Customer"."Customer" = '{?Company}' SELECT * FROM...
  4. begin2know

    Combining Update and Select in Crystal's SQL Command

    I've read through the various threads with much interest in using Crystal's Add Command capability, but can't figure out how to combine Update and Select statements in one query. I've tried using a semicolon and parentheses-- with the semicolon I get "Characters found after end of SQL...

Part and Inventory Search

Back
Top