Search results

  1. F

    Ms Access Query Issue

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

    Some Explanation

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

    Grid Line Issue in Excel Sheet

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

    automatic calculation issue

    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 .:(
  5. F

    Parater Value Issue

    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;
  6. F

    MS Access Query Issue .

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

    Some Explanation with Access Query

    can anybody tell why this Ms Access query is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';
  8. F

    Some Explanation with Access Query

    can anybody tell why this Ms Access query is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';
  9. F

    Some Explanation with Specific query

    can anybody tell me ?.Why this query is not is not working .Kindly let me know the idea.Any help would be highly appreciated. SELECT AccessRole.emp_ID, AccessRole.FormID FROM AccessRole WHERE AccessRole.emp_ID='281' and AccessRole.Form_id='4';
  10. F

    Query

    sir i am writing background query to retrieve last of qty i am having production consumable product,maintenance consumable product with product_id M1 TO m1000 and tools consumable product(t1 to t1000). i want to retrieve item_code, productname, unit, max(ID) AND LAST Qty i am getting all...
  11. F

    Firoz Ahmed

    Kindly help me I am having a table production which table consists productname, item_code,qty and approx 1000 records in that there are three type of product_id p1,p2, p3 ....to p300 product_id is for production consumable m1, m2,m3 .....to m700 product_id is for maintenance consumable rest...
Top Bottom