How do I bulk amend data in a table?

[petehepple]

Hi there,

Hope you can help me with what (I hope) is a relatively straightforward macro. I have a table in a shared database that contains a date field (dd/mm/yyyy). For reporting purposes, we need each date to begin 01 (i.e., 01/03/2012), but our users sometimes forget and enter the actual day of the month instead (24/03/2012). I'm a bit of an enthusiastic amateur when it comes to things like this, and didn't get very far with this myself - is it possible to create a macro that would simply replace the first two numbers of each record in a column with "01"?

Thanks,

Pete

 

[tinyevil777]

Hello Pete,

You might want to a little research on 'Update Queries', this will do what you need.

 

[petehepple]

Fantastic, that's exactly what I was looking for, thanks!

 

[tinyevil777]

Most welcome!