Cc007
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 2 articles for 0.302 sec
Hi Jeff, Thanks for your reply, but where would I insert this, if I put Select Top 3 at the beginning I only get the Top 3 (i.e. 3 results), as I have 5 business units I want to get the Top 3 for each (by Spend, so 15 results in total... Thanks for your help, Louise "Jeff Boyce" wrote: > SELECT TOP 3 ... > > -- > Regards > > Jeff Boyce > www.InformationFutures.net > > Microsoft     

Group: microsoft.public.access.queries · Group Profile · Search for Cc007 in microsoft.public.access.queries
Author: Louise
Date: Apr 19, 2008 08:27

Hi, I have the below query, I have copied the SQL.. I want this query to show the Top 3 Cost Centres with the Highest Spend by Business Unit Names. EXAMPLE FOLLOWS: Business Unit 1 CC123 £76000 Business Unit 1 CC234 £70000 Business Unit 1 CC345 £15000 Business Unit 2 CC007 £88000 Business Unit 2 CC111 £6000 Business Unit 2 CC903 £1000 etc... SELECT [QryImport].[Invoice
Show full article (1.48Kb) · Show article thread
    

Group: microsoft.public.access.queries · Group Profile · Search for Cc007 in microsoft.public.access.queries
Author: Louise
Date: Apr 19, 2008 02:49

Show full article (0.73Kb)