[AccessD] TOP 30 for multiple theaters.

Well indeed, thats one more to build over night...
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, March 15, 2005 7:33 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] TOP 30 for multiple theaters.

Hi Erwin

You didn't tell about website access.
If that is the purpose, I would build a lookup table for that which I
would recreate every night.

/gustav

>>> Erwin.Craps at ithelps.be 15-03-2005 15:28:36 >>>
Ok, this seems to work, was not able to fully verify because:

One downside.
The query was already running for 20 minutes for the year 2004 when I
interupted it....

(the table has about 300,000 records at this date)

In the meanwhile I have wrote the VBA code to do this.
I find it a petty because, using temp tables make parametrible website
access far more difficult.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com