Convert text: 100% to a number: 100

[Core]

I have a field called "test scores" which is currently set as Text with entries like "89%"

How would I go about changing these to just the number so I can create field to manipulate the data?

I tried changing from text to number but it changed them all to 1.

There are several thousand entries so deleting the "%" manually would like to be avoided

Regards,

 

[Galaxiom]

Val(Replace([fieldname],"%",""))

 

[Core]

Sorry where would i put that?

Regards,

 

[Brianwarnock]

As a new field in your query.

if you wanted to change your table then create a new field in the table as a number field then run an update query against it selecting the new field and putting that code in the update to.

brian

 

[Core]

Got it, thanks!!!