Tammy1
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 1 articles for 0.302 sec
I have these 3 queries in ACCESS but I'd like to be able to do the same thing in EXCEL. Can anybody translate these three queries to something I can use in EXCEL? Query Tammy1 SELECT Jan14.RTC, Jan14.AirportCode, Jan14.Date, IIf([Type]="Independent Contractor",[ServiceOrders],0) AS ContractorServiceOrders, IIf([Type]="Agent",[ServiceOrders],0) AS IndependentAgentServiceOrders, Jan14     

Group: microsoft.public.excel.misc · Group Profile · Search for Tammy1 in microsoft.public.excel.misc
Author: Tammy
Date: Jan 18, 2007 09:31

Show full article (1.14Kb)