How to join field in correct format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

SELECT ([Netting Date] & (" NETTING")) AS Comment, Statements.[Netting Date
FROM Statement
GROUP BY ([Netting Date] & (" NETTING")), Statements.[Netting Date ]

I want to hold in the comment field ' Apr 04 Netting ' NOT ' 25/04/2004 Netting ' How do I do this? Formating the Netting date field doent help
 
Have you tried:


SELECT Format([Netting Date], "mmm yy") & " NETTING" AS Comment, [Netting
Date]
FROM Statements
GROUP BY Format([Netting Date], "mmm yy") & " NETTING", [Netting Date];

?

--
HTH
Van T. Dinh
MVP (Access)


Martyn said:
SELECT ([Netting Date] & (" NETTING")) AS Comment, Statements.[Netting Date ]
FROM Statements
GROUP BY ([Netting Date] & (" NETTING")), Statements.[Netting Date ];

I want to hold in the comment field ' Apr 04 Netting ' NOT '
Click to expand...
25/04/2004 Netting ' How do I do this? Formating the Netting date field
doent help
 
Back
Top