Splitting a Numerical String - Access 97

  • Thread starter Jon Poste via AccessMonster.com
  • Start date
J

Jon Poste via AccessMonster.com

Hi,
In my AC97 database I have a field [PropertyRef] with 10 single digits in
it. I have written a module that saves each record selected to a Word 97
file using bookmarks.

I have now been given the format of the word report and I need to split out
the [PropertyRef] field into 10 seperate bookmarks (1 digit in each) but
still maintain a single number in the database.

Could anyone assist me with this?

Cheers
Jon
 
V

Van T. Dinh

If [PropertyRef] is a Text Field, you can use the Left, Mid and Right to
extract a single digit character out of the String.

Check Access VB Help on the above functions.
 
J

Jon Poste via AccessMonster.com

Thanks for your reply. I thought there was a function for it.

Regards
Jon
 
Top