I need a macro quick.

[jetstrike]

I need a macro that will find all instances of a number and replace it with text.

 

[ColinEssex]

Use an update query. But if you have a number field you can't put a letter in it.

Col

 

[jetstrike]

It is a text field so it can store anything but i cant get my query to work how should i set up the update query???

 

[ColinEssex]

Marvellous thing this Access help button

Change records as a group using an update query

1 Create a query, selecting the tables or queries that include the records you want to update and the fields you want to use for setting criteria.

2 In query Design view, click the arrow next to Query Type on the toolbar, and then click Update Query.

3 Drag from the field list to the query design grid the fields you want to update or you want to specify criteria for.

4 In the Criteria cell, specify the criteria if necessary.

5 In the Update To cell for the fields you want to update, type the expression or value you want to use to change the fields.

Col

 

[jetstrike]

Woot i got it! Now that i have the update query set up i will be modifying about 13 fields at once each will have around 700 records should i run 13seperate queries or 1 big query since they will all have to be modified. Also what is the best way to modify records as thgey are recorded like as soon as the record is finished being added it is updated.... Can i update just the most recently created record?

 

[jetstrike]

Another question can i update a field with a value from another table. how would i go about doing this?

 

[Rich]

Why would you want to replace all numeric values with their textual equivalents?

 

[Bat17]

if you add a number to a text field it will become text, no need to do anything! if you change a text field to a number field Access will convert a text number to a real number and drop any records for that field that contain non numeric data.

Peter

 

[jetstrike]

Hey i just do what my boss wants me to do i told them it wouldnt make any sense... This is why the real world sucks

 

[Bat17]

Do you have this sorted now then?

peter