FWIW, I know you can't do that in Access

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #24,338 by tseliot 1/14/02 4:28:50 PM Reply	FWIW, I know you can't do that in Access It won't allow ordering by an aggregate value. You'd have to either use a stored query, or build a new intermediate table. Other DB's, I am sure, are more powerful and will do what drew et al say they will. --------------------------------- A stupid despot may constrain his slaves with iron chains; but a true politician binds them even more strongly by the chain of their own ideas;...despair and time eat away the bonds of iron and steel, but they are powerless against the habitual union of ideas, they can only tighten it still more; and on the soft fibres of the brain is founded the unshakable base of the soundest of Empires." Jacques Servan, 1767
Post #24,342 by nking 1/14/02 4:37:45 PM Reply	Uh, how about an Access Query based on an Access query? Do one query that generates the sums, etc. Then a second query based on the first that groups them. Access queries can be based on another Access query. Quite a useful thing to do in Access. "Will code Visual BASIC for cash."
Post #24,615 by tseliot 1/16/02 11:54:30 AM Reply	That's kinda what I meant by intermediate table whether that's recalced on the fly with a second query or INSERT INTO doesn't matter much to me --------------------------------- A stupid despot may constrain his slaves with iron chains; but a true politician binds them even more strongly by the chain of their own ideas;...despair and time eat away the bonds of iron and steel, but they are powerless against the habitual union of ideas, they can only tighten it still more; and on the soft fibres of the brain is founded the unshakable base of the soundest of Empires." Jacques Servan, 1767

How to build this SQL statement? - (inthane-chan) - (11) - Jan. 13, 2002, 10:27:42 PM EST

Possible answer, not tested - (drewk) - (5) - Jan. 14, 2002, 10:31:51 AM EST

That's the real problem... - (inthane-chan) - (2) - Jan. 14, 2002, 01:36:29 PM EST

Uh yeah? - (nking) - Jan. 14, 2002, 01:46:48 PM EST

I'll try to try it when I get home - (drewk) - Jan. 14, 2002, 03:08:35 PM EST

Looks right to me - (SpiceWare) - Jan. 14, 2002, 04:19:37 PM EST

Oughta work in Oracle, anyway, AFAIK. -NT - (CRConrad) - Jan. 14, 2002, 05:39:40 PM EST

FWIW, I know you can't do that in Access - (tseliot) - (2) - Jan. 14, 2002, 04:28:50 PM EST

Uh, how about an Access Query based on an Access query? - (nking) - (1) - Jan. 14, 2002, 04:37:45 PM EST

That's kinda what I meant by intermediate table - (tseliot) - Jan. 16, 2002, 11:54:30 AM EST

Here's one way - (rickw) - Jan. 14, 2002, 07:36:48 PM EST

Subqueries - (ChrisR) - Jan. 15, 2002, 07:23:17 PM EST

iwethey.org

It was April the 41st. Being a quadruple leapyear, I was driving in downtown Atlantis. My Barracuda was in the shop, so I was in a rented Stingray... and it was overheating.
44 ms