calculated field.

[Julian Redondo]

I wish show a calculated field in a query.
I have a data field, and i wish show the number of week.
After read the help online i understand i will write
Week : Format([DataField];"ww";vbMonday)
the problem is that i have a spanish versión of Acces.
If I write
Week : Format([DataField];"ww";1)
Access write
Week : Format([DataField];"""ww""";1)
I am working with a spanish versión of access.

and if i write
Week : Format([DataField];"ss";1)

Them access do not rewrite my expresion but obtain 00

in englis week ->"ww"
in spanish semana them i suppouse "ss"
week--semana

sorry by my english and thanks

 

[Guest]

Try using single quotes instead of double quotes ...
Also ... I think "Week: is a Reserved Word in Access and should not be used
as the name of your Expression or any other object in your application ...

R. Hicks