Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Code please :)

Status
Not open for further replies.
Tanya556

Tanya556

Technical User
Apr 5, 2002
34
US
In Access, is there a code that will automatically change a query to show the current calendar year quarter?

Thank you.
 
Sort by date Sort by votes
Hi.

format(Now(), "q")

will give the current date (Now()) in respect of its quarter, so,

format(mydate, "q")

would do the same for a field mydate.

Mr Big Dont be small. be BIG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
atadbitslow
  • Locked
  • Question
need help with syntax for a date
Replies
3
Views
429
dhookom
dhookom
qqp
  • Locked
  • Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
381
Andrzejek
Andrzejek
marnb
  • Locked
  • Question
I need outlook to send out an email
Replies
2
Views
295
dhookom
dhookom
iamchemist
  • Locked
  • Question
I have a need to create a single-re
Replies
1
Views
221
combo
combo

Part and Inventory Search

Sponsor

Back
Top