Search results

this works.

This works, thanks

ca can u help solving my problem ?

SELECT DataBase.[Regi No], DataBase.[Farmer Name], DataBase.Village, DataBase.Taluka, DataBase.District, DataBase.[MIS System], DataBase.[Area (Ha)], DataBase.[Sent to GGRC Date] FROM [DataBase] WHERE (((DataBase.[Sent to GGRC Date]) Between DateAdd("yyyy",-1,fnFinancialYearStart("date")) And...

Thanks for the reply. but isnt it between fnFinanciyearStart And FnFinancialyearEnd ???

hi there, can u pls give me the same code to get previous financial year data?

well let me try to work on your suggested path and will revert back if struggle in doing it.

My specific needs are, 1. Each farmer has assigned unique Registration Number, there must not be duplicate registration number in farmer table. 2. But each farmer can have multiple Dispatch orders and so multiple invoices. (that's why i need to copy all data to dispatch order table because i am...

My specific needs are, 1. Each farmer has assigned unique Registration Number, there must not be duplicate registration number in farmer table. 2. But each farmer can have multiple Dispatch orders and so multiple invoices. (that's why i need to copy all data to dispatch order table because i...

Actually CustomerT = FarmerT CustomerID = FarmerID i have mentioned it as customerT for easy understanding. i have attached my database file for reference. Please look to "NewdispatchorderF" i have created a combo box for regi no. This is the place where i need to pull all data from...

I have make the query and select it as record source of my form, and created a combo box but still not able to get the data, below i my sql view of query, SELECT DispatchDetailsT.FarmerID, DispatchDetailsT.RegiNo, DispatchDetailsT.FarmerName, DispatchDetailsT.Village, DispatchDetailsT.Taluka...

Hi all, I have a table named "CustomerT" which has several fields like, - CustomerID - CustomerName - CustomerCity -CustomerContactNo Now i have another table named "DispatchOrderT". I need to copy all the customer details like, Name,City and contact no to this table bases on a form with...

Screenshot attached herewith.

This query finally solves my problem, thanks for the assist, SELECT CustomerT.CustomerName, ProductT.ItemCode, ProductT.Description, TotalOrderT.Quantity AS [Total Quantity], DispatchOrderT.DispatchOrderDate, OrderDetailsT.Quantity AS [Do Quantity], [Total Quantity]-[Do Quantity] AS [Remaining...

It gives an error while opening Northwind Databse developer edition

Hi there, View Total PO Material query is to verify total order items anytime while making DO. Later my plan is to limit Total DO quantity to not more than entered PO quantity. (I still not able to find logic on how to do it though :P) It would be great help if u make that query for me on my...

Hi all, I am trying to create a purchase order management system. there are main three stages of it, 1. Create a Purchase order (Create a customer with total quantity) 2. Create a dispatch order from the total quantity entered while making PO or customer. There are several Dispatch orders...

I have followed the exact path. anyways removing one table and linking customer table to Orderdetails table solve my problem instantly.

my file size is too big to attach here, so i've shared it via media fire. Ofcourse i've tried Arnel's suggestion but its not what i want.

Did u take a look at the FDMS File i have attached? i am trying to do the same thing here, but not worked? what is wrong?