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 Chriss Miller 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 Boomn4x4

  1. Boomn4x4

    What does $^0 mean

    I'm looking at a perl script and I see a test for '$^0', what does that mean? Sorry for asking such searchable question, but google doesn't like special characters... so I can't search for it.
  2. Boomn4x4

    Group by week

    OK, I've gotten this far - SELECT datepart("ww",DateLogged) as Week_Number, COUNT(CallType) AS call_count FROM tblLog WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS' Group By datepart("ww",DateLogged); I want to also calculate the...
  3. Boomn4x4

    Group by week

    I should also mention this is in Access, it may make a difference
  4. Boomn4x4

    Group by week

    yes the field is DateLogged
  5. Boomn4x4

    Group by week

    SELECT COUNT(CallType) AS call_count FROM tblLog WHERE CallType = 'Software/May-PS' OR CallType = 'Report Regeneration-PS' OR CallType = 'Training/Info-PS'; I want to show the Count of each individual week in the data base
  6. Boomn4x4

    Group by week

    I have a simple count querey how do I group it by 7 day weeks of the year? Sun - Sat
See more

Part and Inventory Search

Back
Top