asp query help

[fran7]

Hi, I wonder if anyone has an idea how this could be expressed in a query.

There are two tables.
one is for the last visit date like 02/08/2009 11:41:31 field= (latestvisit)
the other records the number of visits. field= (hit_count)

I want to sort the results on the page by a combination of these two

A mathamatician friend wrote this saying someone would understand it. either this

+ rank[rank[-hit_count] +rank [-latestvisit]]

or

- rank[rank[hit_count] +rank [latestvisit]]

Any idea how this could be expressed in a query.
Thanks for any pointers.
Richard

[jhardman]

Richard,

This question isn't really related to ASP, and is entirely dependent on the db you are using. Did you say this was an access db? If so, I'll move it over to the access forum for you.

Jared