MSAccess + Creating an image slideshow

[Gaby Sandoval]

i currently use a SQL statement on my website to display a group of
images (more specifically their location on the server) and links from
the access database. only images that meet certain criteria are
displayed in a table with the logo in one column and corresponding
text link in the other column.

the goal i have is to do away with this and instead of a very large,
to make an image slideshow that scrolls through all the logos. i know
i can hardcode this (each logo and link) using javascript but because
the images are constantly changing based on the criteria on the access
database, id rather find a way to make a slideshow code dynamic using
a sql statement.

the images when clicked would go to the web address of that logo.

any ideas how this can be done? can somebody point me in the right
direction.

thanks,
gabriel