how to make hyperlink from all record in a query

[togneri]

I hope some one can help me hear as i am fairly new in this forum.
I have been using access from some time time and have come across a problem i and not shore how to solve.

I have query that contains a field which is a 6 digit number.
the number of record in query can change from day to day with anywhere between 1 to 100 records.

what i am looking to do is to create a hyperlink that access can follow that will contain a constant text stringof say
"www.mywebsite.com/order.aspx?sItems=[record1],[record2],so on untill all reocrds are filled.

Any help with this problem would be much appreciated


regards

steve

 

[fastmike]

all you had to do is use VBA and type application.hyperlink in help and you will see the code. still need help post it over here. and can you give more information
Thanks