Search results

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

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

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

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

I have two tables PO Detail table having [PO number] and [supplier] fields and PO payment table having [ID] field to autonumber and [PO number] and [invoice number] fields. On the form of PO detail table i have made after update event of DoCmd.RunSQL " Insert into [PO payment]([PO number]])...

I am new to access and have small inventory database in which i have two queries category wise consumption having fields ID, Item, and Category and other query Pending Purchase Requisition Query having fields ID, Item, PR Date, PR QTY, and GRN No. I want to sum PR Qty of each item present in...

i have report based on query in which group is set to supplier name when i run the query grouping is also done on those records in which supplier name field is blank i want to make no group on those records in which supplier name field is blank and also want to skip supplier name in which...

is it possible to stop access report for recalculating fields during scrolling to view report smoothly during scrolling

I want to make running sum in Query for this i use dsum function. i have made two criteria parts separately and both criterias are working when applied individually. First one as RT: DSum("[Actual Quantity]","[Inventory Transactions Extended]","[TransactionID]<=" & [TransactionID]) And Second...

I am new to this forum.