automatic update in quarter text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nick - 06 May 2007 08:35 GMT

I have a form where the OTDLdaTe text box is entered and woud like the the
quarter field to automaticly have the correct quarter entered. I currently
have to enter the "Quarter"
I do not know where to start and in which text box use.
Quarter 1 = 01/01/2*** and < 04/01/2*** and so on.

Reply to this Message

Douglas J. Steele - 06 May 2007 12:40 GMT

Assuming the date's in text box txtDate, set the control source of text box
txtQuarter to =DatePart("q", Me.txtDate)

Note that this will only display the quarter on the form: you will not be
storing the quarter in the underlying recordset, which is the way it should
be: you shouldn't be storing calculated data in the table.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a form where the OTDLdaTe text box is entered and woud like the the
> quarter field to automaticly have the correct quarter entered. I currently
> have to enter the "Quarter"
> I do not know where to start and in which text box use.
> Quarter 1 = 01/01/2*** and < 04/01/2*** and so on.

Reply to this Message