Fill a Field with the same value

[samerman]

Hello,

I'm new to access and i need help in filling a certain field with the same value.
In fact i have data representing one quarter of data and i need to add a column called "Quarter" in which i paste the same value: the current quarter : "Q4".

How can i do that?
I think this is a real simple issue.

Thanks in advance for your help.
Regards
sam

 

[Mile-O]

UPDATE MyTable SET MyField = "Q4";

Although the question must be asked - why not just store the exact date? It offers greater flexibility and, by using the Format() function you can get the quarter from any date.