Search results

  1. W

    Solved DSum Criteria

    Thanks Alot ebs17 I finally solved by formating date parameter to SQL standard (yyyy-mm-dd) format and acheived desired result. Thanks Alot.
  2. W

    Solved DSum Criteria

    Yes off course both solved Thanks alot for guidance.
  3. W

    Solved DSum Criteria

    This Worked Thanks Alot CJ_London and Josef P.
  4. W

    Solved DSum Criteria

    Thanks Josef P. I have followed your code as given =DSum("[Quantity]","[Inventory Transactions]","[Created Date]<=#" & [Inventory Transactions].[Created Date] & "# AND [Transaction Item] = " & [Inventory Transactions].[Transaction Item]) But Results are given in attachment. DSum is not...
  5. W

    Solved DSum Criteria

    I do't want to group my data. I need running total of each item quantity in separate field As there is difference to execute DSum function criteria for text, number and date fields . Mine Transaction item field type is number and created date field type is Date.
  6. W

    Solved DSum Criteria

    I want to do running sum in Query for this i am using DSum function. I have Inventory Transactions table with Created Date, Transaction Item, quantity and description fields. I have made query with all fields of this table and want to do running sum with Created Date wise and Transaction Item...
  7. W

    Solved DSum Criteria

    Actually I have three tables 1- Inventory Table (Containing ID, Item and Category fields) 2- Inventory Transactions Table (Containing TransactionID, Created Date, Transaction Item, Transaction Type, Description and quantity fields). 3-Transaction Type Table (Containing ID and Transaction Type...
  8. W

    Solved DSum Criteria

    Dear This is working well but now i want to run dsum with date criteria instead of TransactionID criteria. I am using this code DSum("[Actual Quantity]","[Inventory Transactions Extended]","[Inventory Transactions].[Created Date]<=#" & [Inventory Transactions].[Created Date] & "# AND...
  9. W

    Writing Multiple criteria in DSUM function

    Thanks Alot Plog I applied single single step and finally succeeded. Thanks Alot for your guidance.
  10. W

    Writing Multiple criteria in DSUM function

    Thanks Alot Arnelgp this worked well
  11. W

    Writing Multiple criteria in DSUM function

    I want to take last date of month that was two months before (As this month is July I want to take last date of May), I am using this formula =DSum("[Quantity]","[Inventory Transactions Extended]","[Inventory Transactions].[Created Date]>...
  12. W

    Writing Multiple criteria in DSUM function

    Thanks Alot Plog, I try to apply criteria one by one.
  13. W

    Writing Multiple criteria in DSUM function

    I want to calculate previous month total quantity where generic and category fields are the same the quantity should sum up in access query Last Month Qty: DSum("[Quantity]","[Inventory Transactions Extended]","[Transaction Types].[Add/Remove]='Removal' and [Inventory.Generic] = " & [Generic]...
  14. W

    Combo Box filtering

    Thanks alot i have removed batch no from issuance table and taking product name from purchasing Many many bundle of thanks
  15. W

    Combo Box filtering

    Hi I am new in access and i am confused how to handle data. I have three tables One table Product Name having fields ID, Product Name, Generic Second Table Purchasing having fields ID, Product Name (linked with table Product Name with one to many relation), Batch No, Rate, Qty and Date Third...
  16. W

    Create Function inside VBA With multiple variables

    Thanks Alot for guidance now every thing is going fine.
  17. W

    Create Function inside VBA With multiple variables

    My code is now working well all results are coming upto the mark but while Item_PO_Qty field or GRN_Qty fields are blank then #Error comes. How to get rid of this error. now my working code is like this Function POStatus(VarApprovalStatus As Integer, Item_PO_Qty As Integer, GRN_Qty As Integer)...
  18. W

    Create Function inside VBA With multiple variables

  19. W

    Create Function inside VBA With multiple variables

    Hi, I am new to vba programming and i dont know much basics about vba. I want to make the function that shows the status of purchase order just like this Function POStatus(VarApprovalStatus, Item_PO_Qty, GRN_Qty) If VarApprovalStatus = 3 Then POStatus = "PO Cancelled" ElseIf...
  20. W

    Insert into function

    Thanks alot it worked
Top Bottom