|
|
 next
|
  Subject: need help in converting this access query to an xml query
Author: cheryl culwell
Date: 13 Oct 2010 03:17 PM
|
I am new to XML and have a deadline to meet, I know my learning XQL will not get me to the finish line in time...can I get help to convert this to an XML query?
thanks in advance
SELECT Wells.APICode AS FACId, Format([YearMonth],"mm/yyyy") AS FacREport, "0" AS FacAmend, "Well" AS FacType, Wells.UserField9 AS FacFormation, Wells.WellName AS FacName, Wells.Status AS FacGroup, "None" AS FacComment, "" AS Production, "OIL" AS ProdType, Round(([AllocBegInventory]),0) AS [Prod Begin Inventory], Round(([AllocEndInventory]),0) AS [Prod End Inventory], "bbls" AS ProdUnits, Round(([AllocOil]),0) AS [Prod Quantity], Well_Summary.DaysOn AS [Prod Days Producing], "" AS Disposition, "SOLD" AS DispType, Round([AllocOilSold],0) AS [Disp Quantity], "" AS EDisposition, "" AS Disposition2, "BSW" AS DispType2, IIf(Round([Prod Quantity])<0,(Round([Prod Quantity]*-1)),0) AS [Disp Quantity2], "" AS EDispostion2, "" AS Disposition3, "USED" AS DispType3, Round([AllocOilUsed],0) AS [Disp Quantity3], "" AS Edispostion3, "" AS EProduction, "" AS Production1, "Water" AS ProdType1, "bbls" AS [Prod Units1], Round([AllocWater],0) AS [Prod Quantity1], Well_Summary.DaysOn AS [Prod Days Producing1], "" AS EProduction1
FROM ((Wells RIGHT JOIN Well_Summary ON Wells.WellID = Well_Summary.WellID) LEFT JOIN Company_Info ON Wells.WellOperator = Company_Info.Name) LEFT JOIN Leases ON Wells.LeaseID = Leases.LeaseID
WHERE (((Wells.UserField9) Is Not Null) AND ((Wells.Status) Not Like "P&A") AND ((Well_Summary.YearMonth)=[Enter Year & Month Like "2004/02"]) AND ((Wells.State)="nd") AND ((Wells.WellOperator) Like "*petro*") AND ((Leases.ClientID)=15))
ORDER BY Wells.APICode, Wells.WellName;
|
|
|
|
|
top