Access 2007 Date Format

[dalgo]

I have converted an old database to Access 2007 and find I need to edit my queries that use the date format function.

eg change from Format([date],'yyyy') to Year(date)

I can change each query manually but is there a quicker way to do this?

 

[pbaldy]

I use a tool called Speedferret, but it costs a bit. I've heard that this free tool can do the kind of find/replace you're looking for.

http://www.skrol29.com/dev/en_vtools.htm

 

[dalgo]

Thanks for your help. Vtools looked to be just what I want. Unfortunately I was unable to install it. As well as security warnings the product did not like my version of Access 2007 although it is up to date. I tried several times but eventually it was quicker to change the queries manually.