Hi! Using Access97, i have a que

[Aietoe]

Hi!

Using Access97, i have a query that creates a table with many fields that are used afterword in a mailmerge with Word.
One of the field is a date that i format the following way:jjjj" le "j\ mmm", "aaaa
and the date comes out in the table like this:Mercredi le 14 aout, 2001 .

I would like to create the same kind of query for my english speaking customers. So i would like the date to come out like: Wednesday august 14, 2001

Would anyone know how i could do it.

Thanks

Aietoe

 

[RichUK]

Try Format(MyDate, "dddd mmmm d, yyyy&quot

 

[Aietoe]

Hi RichUK,

Nice try but it still comes out in the french format:
mercredi aout 14, 2001

...... but please keep on giving me ideas to try.... i don't have any more myself.

Aietoe