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 derfloh 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 LughS

  1. LughS

    chart format question

    You may get mileage out of the option to put the labels on the "sides" of the chart. Chart Options > Data Labels > Labels on sides However, you may still get some overlap. You can sometimes move the labels a bit. However, you can't move them much. And, the exact amount by which you can move...
  2. LughS

    Conditional summary?

    Use a formula to alias, like so: SELECT {myfield} CASE 1: "Data Entry" CASE 2: "Missing Data" CASE 3: "Old Data" CASE 4: "Virtual Data" DEFAULT: "Good Data"; Or, since you are using simple numbers, you can use an array-based solution. ["Data Entry","Missing Data","Old Data","Virtual...
  3. LughS

    Insert Count from Table Not in Details Section

    Personally, I think you need to set Crystal aside, and go back to Access. I think you can solve this problem much more easily in the source database. First, what is the relationship between tblRequestedInformation and tblNewCustomers? One to many? Many to many? I.e., do you have records in...
  4. LughS

    Dynamic Columns Question

    Have you looked into using a crosstab? Everything you are saying there, especially the dynamic number of columns, sounds like that's what you want.
See more

Part and Inventory Search

Back
Top