try the same query with ORDER BY clauses in both the query and it's
sub-query, if there is a sub-query.
~Simon
Simon Horwith
Macromedia Certified Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 500
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-----Original Message-----
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 4:07 PM
To: CF-Talk
Subject: TOP function not performing
Why doesn't the TOP function ever work in Access? Sometimes it works,
sometimes it doesn't - most of the time it seems it pulls a random record.
Is there a way round this?
Thanks
Will
--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
