CODEWITHSUNDEEP
ms-access
Paintballborg
Paintballborg

Reputation: 63

Trying to display the current month as a specific letter in an Access expression

I need to make the default value for a certain field in Access be a certain letter representing the current month. For example, the month of January displays "A" the month of February displays "B" etc.

What I have now is:

=(Month(Now()),"A","B","C","D","E","F","G","H","I","J","K","L")

Upvotes: 2

Views: 62

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123839

Try opening the table in Design View and setting the Default Value property of the field in question to

=Chr(Asc("A")+Month(Date())-1)

Upvotes: 1

Related Questions