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

    SQL Group By's displaying zeros

    First off, I am using Access 2002. I have a data set, and i am trying to Group By certain demographic files in my db (q59 as Sex1, in this example). Here is the code I have so far: select 2 as QID, 1 as RID, "Yes" as QText, count(Q2) as Result, Avg(Q59) as Sex1 from sheet1 where Q2 = 1 group...
  2. Zak8022

    Cross-tab row suppression

    Ok, I am running Crystal 9.2.0.448, and I need help on a cross-tab i am creating. I have 5 possible data points (1 thru 5) and I have it set up to display in a specific order. However, if it happens that my data set does not contain any 1's (for example) , Crystal supresses that row. Ideally...

Part and Inventory Search

Back
Top