Recent content by firoz.raj

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...