Incrementing file name field...?

[mobytonez]

Hi,
I am reasonably new to access and i am having a little trouble with what i would expect to be a simple problem to fix.

What i am trying to do is this...
I have a table set up to work with an asp web page. each record in the table has a unique ID which is set to autonumber.
I also have a field which hold the URL of an image used in the asp file. The address remains the same for all of the records except that the file name it points to increments by one each time.
example:
the record ID is 173 and the file address is:
http://www.berkeley.tv/thumbnails/thumb_173.jpg

Basically, if i could automatically take the ID number and enter it after 'thumb_' it would all work fine.

Hope someone can help me out,

Thanks in advance.

 

[JimH]

Hi,

You didnt mention wether or not your using a query to create your web page, if so, simply add another colum in your query:

Right now you have:

AutoNumber Websiteaddress Filename

Change to:

Desiredoutput: [websiteaddress] & [autoNumber] & [filename]

Then, on the query output to the web page only have Desiredoutput checked.

Be careful about adding a space between your naming conventions as is your example. the filename was cut off in your web.


HTH