Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SQL to VBA ??
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.ServiceOrders FROM Jan14; Query Tammy2 SELECT Tammy_1.RTC, Tammy_1.Date, Tammy_1.AirportCode, Count(Tammy_1.AirportCode) AS CountOfAirportcode, Sum(Tammy_1.ContractorServiceOrders) AS SumOfContractorServiceOrders, Sum(Tammy_1.IndependentAgentServiceOrders) AS SumOfIndependentAgentServiceOrders, Sum(Tammy_1.ServiceOrders) AS SumOfServiceOrders FROM Tammy_1 GROUP BY Tammy_1.RTC, Tammy_1.Date, Tammy_1.AirportCode HAVING (((Tammy_1.RTC)="dfw")); Query Tammy3 SELECT Tammy_2.Date, Tammy_2.AirportCode, Tammy_2.SumOfContractorServiceOrders AS IC, Tammy_2.SumOfIndependentAgentServiceOrders AS Agent, Tammy_2.SumOfServiceOrders AS ServiceOrders, ([SumOfContractorServiceOrders]/[SumOfServiceOrders]) AS PercentICUtilization FROM Tammy_2; |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|