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 AllMememe

  1. AllMememe

    SQL Problem with selecting dates

    Worked great! Thank you! :)
  2. AllMememe

    SQL Problem with selecting dates

    I have a table called Match which has columns DateFrom and DateTo. I need my query to get all records that have their DateFrom OR DateTo between two selected dates. I tried: Select distinct P.FName, M.Team from Match M Person P where P.Team = M.Team and M.DateFrom OR M.DateTo between...
  3. AllMememe

    SQL problem in Access - Group by and order by Month name

    Apologies for bothering you again but how can I get the above to only include dates in 2011? Thanks :) I have: SELECT Format(LicenceExp,'mmm') AS [Month], Format(LicenceExp, 'yyyy') as [Year], Count(*) AS Occ FROM Licence GROUP BY Format(LicenceExp,'mmm'), Month([LicenceExp])...
  4. AllMememe

    SQL problem in Access - Group by and order by Month name

    All the above worked perfectly thank you!! I'm not too concerned about all months for now but thanks dhookom, I'll check out having a months table. :)
  5. AllMememe

    SQL problem in Access - Group by and order by Month name

    I need to get the name of each month that an expiry date exists and the number of expiry dates per month. SELECT Format(LicenceExp,'mmm') as Month, count (*) as Occ from Licence group by Format(LicenceExp,'mmm') order by Format(LicenceExp,'mmm') DESC Results: Dec 1 Jun 1 Oct 2 Jul...
See more

Part and Inventory Search

Back
Top