Access Virgin
Registered User.
- Local time
- Today, 19:18
- Joined
- Apr 8, 2003
- Messages
- 77
I have an access table that is backing up a web page. One of the fields that is contained in the table is rlo_number, which is 2 digits. What i want to do is to be able to format this so that field in the database reads rlo.[rlo_number].html, so if the user types in 55 in the web page then the field in the table stores rlo.55.html, i got something similar to what i want working with using an input mask of rlo.99.html, but if the user enters only 1 digit then a space is left (ie rlo.6 .html), this is no good to me.
Is what i am looking possible. i know how to go about this with forms/ reports but all this database has is the 1 table
Is what i am looking possible. i know how to go about this with forms/ reports but all this database has is the 1 table