I need some help putting together some commands in Access 2003.
## Deliverables
In Access 2003, I need:
1. To take the value of a field for example RMA_Number 12345 and change this into *12345* and save it into another field for example Barcode.
2. Based on the values of 3 fields, we need to be able to create a full http address and then push this into the browser. For example:
<[login to view URL]>
&orderno=XXXXX&email=XXXXX
where RMA, Orderno and Email are fields in the table. For each record, it needs to populate the XXXXXX with the values for that record. A button on the form will then send the complete completed http address as below to the browser.
<[login to view URL]>
<6&orderno=1082554&email=johnb@[login to view URL]>
Please explain how to do this and provide example code for us to import into our current access application.