Date Part

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

Guest

I am using "QRT: DatePart("q",[My Field],1,0)" and it works great. What I
would like to know is can I have it return QRT 1, QRT 2 etc instead of 1,2,3,
& 4?

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query summing on one line 4
Am I trying to do something that Excel cannot handle? 1
Converting Dates to Fiscal Year Quarters 2
Adding specific Columns in a query/report 3
URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER 1
Why isn't this returning the quarter number? 3
Help with functional design of MDB data 3
Crosstab, Quarter Sum isn't working 6

Back
Top