i have to guestions:
i'm totally new to this access and vba stuff so i would really aprecialte a detailed answer.
1.my first question is: i have a report that inludes a feild that starts with numbers and ends with characters (say "1111test") and i need to get only the numbers how do i do this? i know this is done using vba and some function called "val" but i wasn't able to make the thing work.
2.my second question is: after i'm done with this report i want to export it to a flat file. and no i can't got to file>export. i want it to have no format just raw data. i also know that this is done thru vba and functions like open(), write() but can you add more intfo

thank you very much
and i would apreciate a quick response

Please don’t double post. If you post a question in one forum (as you did in http://p2p.wrox.com/topic.asp?TOPIC_ID=28950), then in the other fora post a reference to the other post, rather than reposting the question.

That way everyone with something to say on the matter can put their comments and suggestions in one place.