Hi All.
I created query with dialog box in Access :
How to convert that query to veiw MS SQL?
Thank.
I created query with dialog box in Access :
Code:
SELECT (Format([Date_P],"mmm yyyy")) AS [Date_P], Result, Count([Date_P]) AS Pos
FROM ABC
GROUP BY (Format([Date_P],"mmm yyyy")), Result, Format([Date_PAP],"yyyy")
HAVING Result<>"neg" AND Count(Date_P>0
AND (Format([Date_P],"yyyy")=[Please, enter year (yyyy):]);Thank.
