Search results

Now i am able to save at least whole query . but why it says Circular reference by alias 'Price' in query definition's select list ? .Kindly let me know please .any help would be greatly appreciated . SELECT IC_Itembarcode.itemID, IC_Itembarcode.Barcode, IC_Itembarcode.Serial1...

Now i think i need to check part by part of this big query .Why the following query does not return anything ?.it Needs to Return the 12/29/2011 from Ic_ItemDefaultprices. SELECT Max(StartDate) FROM IC_ItemDefaultPrices AS B WHERE B.itemID Like 'BUR33* ' And B.startdate<='2011-12-29'

yes that is exactly .but most of time i have worked on sql server .but i need to adapt the this query in access .can you tell me how should i write in nested way to the inner join ? .let me know please . SELECT IC_Itembarcode.itemID, IC_Itembarcode.Barcode, IC_Itembarcode.Serial1...

Can anyone tell me ?.When i try to run the following query it says syntax error(missing operator) in query expression ic_ItemID.itemID =Ic_Itembarcode.ItemID Inner join dbo.IC_Itemdefaultprices p on Ic_ItemID.ItemID=P.ItemID. SELECT IC_Itembarcode.itemID, IC_Itembarcode.Barcode...

i have Installed MsWord 2003 and MsWord 2007 in my Computer .But when i open Either MS Word 2003 or Ms Word 2007 . i got the following attached message .let me know the idea .any help would be highly appreciated.Kindly find the attachment also .

The Problem is that I have so many sheets in One workbook . I want to set for only one Sheet the gridline .but in Other Sheets Grids needs to be Come Automatically .So let me know the idea .how should I achieve this specific task using Macro ???.any help would be highly appreciated .Kindly see...

Hi, Brianwarnock Now I simple want Closing needs to be Come Automatically in the Next Day in the opening coloumn . let me know the idea .How should I Achieve the specific Task ???.Kindly find the attachment .and let me know the idea .:(

Still Nooooooooot Working !!!. here is the following Code . What I have written !!! .Please see the Attachment especially see In the Delegate Chicken Brazil Worksheet_SelectionChange. and please let me know !!!. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 5...

I Simple Want .when user should go on total Column .automatically it needs to be calculated and needs to be come in Total . (Opening + receiving ).let me know the idea .Any help would be highly appreciated .(opening+receiving) calculate value needs to be come in total Cell .:(

Why the following Query is Not Working ???.When I runs the query ???.it tells about Input Parameter !!! .:D SELECT * FROM identityTab WHERE identityTab.IdentityNo=JPPPS;

yes salary for Employee id 3 and 4 is null.But why it is not comming on the basis of Null !!! SELECT Employees.ID, Employees.Name, Salary.Salary FROM Employees RIGHT JOIN Salary ON Employees.ID=Salary.ID WHERE (((Employees.Salary)=Null));

Still Not Working .here is the following Sql Query .What i have written .let me know please . ELECT Employees.ID, Employees.Name, Salary.Salary FROM Employees RIGHT JOIN Salary ON Employees.ID=Salary.ID WHERE (((Employees.Salary)=Null)) ;

Still i did not get the query result of employee id 3 and employees id 4.in the following order .Simple i want to get the Name and Salary of Employee ID =3 and Employee ID= 4 . SELECT Employees.ID, Employees.Name, Salary.Salary FROM Employees RIGHT JOIN Salary ON Employees.ID=Salary.ID WHERE...

Still not working .the query needs to give the output like the following !!!.Let me know the idea . ID NAME SALARY 3 C 4 D

I Have Two table Employees and Salary !!!. I Want to see the following output using query . ID NAME SALARY 3 C 4 D I have written the sql query .but i did not get the in the following order. I want to get in the following order . .The query needs to return ID NAME SALARY 3 C 4 D here is...

why the following query is not working ?.i want to see the Maximum no of itemcode.records on the basis of parameter.if i put p.it show those records which itemtype p.in the same way if i put M.it should show the Maximum No of itemcode on the basis of sItemType parameter.Which is matching with...

Can you demonstrate any example of Append query of Ms Access.Kindly let me know the idea.Any help woud be highly appreciated.i want to see how can i use the append query.Kindly find the attachment also.kindly let me know the idea.Any help would be highly appreciated.

can you tell me in my material table itemcode together with itemtype is a unique.i want to see the max itemcode.in the following way suppose last no is 542 and itemtype is m.then in query 542 is come.same way last no is 543 and itemtype is p.then 543p.So since itemcode together with itemtype is...

Still issue .Kindly let me know .why it is not working. "SELECT PurchaseOrder.PO_ID, PurchaseOrder.RefNo, Suppliers.sup_name, Materials.Productname, Materials.unit, PurchaseOrderDetail.item_code, " & _ "PurchaseOrderDetail.item_type, PurchaseOrderDetail.Quantity...

Can you tell me ?Why this Sql Query is not working.When i tried to save .it is Saying Extra) in Query .Kindly let me know the idea.Any help would be highly appreciated.Kindly find the attachment also. SELECT PurchaseOrder.PO_ID, PurchaseOrder.RefNo, Suppliers.sup_name, Materials.Productname...