Search results

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

SELECT [Inventory Transactions Extended].Inventory.ID, [Inventory Transactions Extended].Inventory.Item, Sum([Inventory Transactions Extended].[Actual Quantity]) AS [Current Stock], [Suppliers Extended].[Supplier Name] FROM [Inventory Transactions Extended] LEFT JOIN [Suppliers Extended] ON...

how to add criteria in query when i write "is not null" in query it does not work

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

when i scroll down opened report scrolling does not occure smoothly it just looks like report is re calculating i am talking about report (report view)that is made on query

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

Thanks Brother it worked

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.