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!
-
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!
-
SQL Problem with selecting dates
Worked great! Thank you! :)- AllMememe
- Post #3
- Forum: Microsoft: Access Forms
-
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...- AllMememe
- Thread
- Replies: 3
- Forum: Microsoft: Access Forms
-
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])...- AllMememe
- Post #6
- Forum: Microsoft: Access Forms
-
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. :)- AllMememe
- Post #5
- Forum: Microsoft: Access Forms
-
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...- AllMememe
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
