#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"