OK,
I would like to ask a question about dates.
Here is my SQL for a query that returns a QTY completed by Month and Year.
SELECT Count(*) AS QtyComplete, Month([BRF_BOF_Complete]) AS TheMonth, Year([BRF_BOF_Complete]) AS TheYear
FROM tblNPI
WHERE (((tblNPI.Status_ID)=12 Or (tblNPI.Status_ID)=17))
GROUP BY Month([BRF_BOF_Complete]), Year([BRF_BOF_Complete])
HAVING (((Year([BRF_BOF_Complete]))=2014));
The result is this:
# BRFcompletedByMonth QtyComplete TheMonth TheYear 9 1 2014 13 2 2014 13 3 2014 2 4 2014
What I want is to display the month as Jan, Feb, Mar, Apr…Dec. instead of 1, 2, 3, 4 etc. How do I accomplish that?
Also if I do that will it migrate to the reports when I create a report for that query?