Help on default Quarter ???? (1 Viewer)

[vividor]

I am not really a beginner on access but I have a little problem on a data base that i am working on, I am trying to set a default value on a text field.
I have a text box field where the user supposse to type in the quarter and the year ( ex. Second Quarter 2002) in words just like the previous example but I would like for this field to do it automaticaly.
I tried the "Datepart" but only give me the quarter in a number..

Any suggestions? sorry that I posted this issue twice but nobody had answer me back since yesterday.

 

[antomack]

Not exactly the format you are looking for but it'll give you something to work from

="Quarter " & DatePart("q",Date()) & " " & Year(Date())

This would give you 'Quarter 4 2002' for today.

Put it in for default value and the value will set for all new records as for the date you are adding the record.

 

[vividor]

Antomack, thanks a lot... definetly this will give me something to think about it...

I was thinking something more like..

If 4 then print"Four Quarter" and then the year..
but I will work something around this...

If any body else has another suggestion, I would appreciate the input..