Hi all,
I have the following query :-
I would like the results to be sorted by BDM_Name, and then Format([DateTPIAgreementSigned],"mmm-yy").
The query runs fine, but is not sorted by date. For example, for one BDM_Name, the lines run in the following order :-
Dec-16
Jan-17
Nov-16
When viewing the query in Datasheet view, I can filter by date as expected. Not sure if it's relevant, but I'm in the UK.
Any ideas how I can get the date sorting working correctly?
Thanks in advance
I have the following query :-
Code:
SELECT tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy") AS Expr1, Count(tblBrokerages.DateTPIAgreementSigned) AS CountOfDateTPIAgreementSigned
FROM tblBrokerages
GROUP BY tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy")
HAVING (((Count(tblBrokerages.DateTPIAgreementSigned))>0))
ORDER BY tblBrokerages.BDM_Name, Format([DateTPIAgreementSigned],"mmm-yy");
I would like the results to be sorted by BDM_Name, and then Format([DateTPIAgreementSigned],"mmm-yy").
The query runs fine, but is not sorted by date. For example, for one BDM_Name, the lines run in the following order :-
Dec-16
Jan-17
Nov-16
When viewing the query in Datasheet view, I can filter by date as expected. Not sure if it's relevant, but I'm in the UK.
Any ideas how I can get the date sorting working correctly?
Thanks in advance