Search results

Hi all, I have a table named "Master Data" having following columns - Regi No - Farmer Name - MIS System - Material Supply Date - DD Or RTGS No - Material Supply Date - TPA Date I am trying to run a query where, - Material Supplied (Not Null) -DD Or RTGS No Pending (Is Null) - TPA Date...

Hi all, I have a table name FinalPaymentT having following columns, - FarmerShareRcvdDate - FarmerShareAmount - PFMSRcvdDate - PFMSAmount - StateTopUpRcvdDate - StateTopUpAmount I need Total of Three Amounts (FarmerShareAmount + PFMSAmount + StateTopUpAmount) sort by three dates where, Dates...

Hi all, I have two tables 1. FarmerT And 2.RTGST FarmerT has a field "RegNo" And RTGST has two fields "RTGSUTR1" And "MailToHO1" Now i need a data having following criteria, - No of cases (RegNo) where "MailToHO1" is not null and "RTGSUTR1" is null this returns as zero records, but actually...

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

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

HI all, i am trying to create a simple order system. done all relationship and sub form matching field. but still got error as per attachment. I am trying to learn this thing so pls guide me what i am doing wrong. I have attached my database and query screenshot. Thank You,

Hi all, I have a table "ProductT" which has following columns, - ProductID - Product Name - GGRC Price - Unit I have created a form named "OrderDetailsF" which get values from table "ProductT". When i select a product from combo box i need relevance price in Price field for this, I have...

Hi all, I have a table which has following columns, - Product Item - Rate - Is Head unit item (yes no field) - Quantity - Amount Now i need sum of amount where "Is Head Unit item" field has value yes. I have tried "Sum(IIF([Is Head Unit Item],1,0)) but not able to get the sum value. How...

Hi all, I have created a customer order entry system, I have tried to follow an online tutorial and make the attached access order entry system. Now I need help on, 1. How to create a new customer and enter order items 2. how to edit items in OrderF (it shows an error) Thanks

Hi all, I have attached here my sample database and a sample report in pdf format. I need to create a query of Sum of "Area" field with the different criteria as under, Dealer Wise sum of "Area" where, Column no-1 : Sum of area where "WO Date' is blank (WO not received) Column no-2 : Sum of...

Hi all, i have a table named "Dispatch details". It has following columns, 1. Dispatch Date 2. Party Name 3. Truck Number 4. Freight Charges I have created a single entry form to enter all details. As per single case dispatch this works but what in case where i have to dispatch for more than...

Hi all, I am trying to generate a payment slip (designed report) from an opened form. I have a form named "payment details" It has following details opened, Note : all data is for example 1. Payment No :123 2.Party Name : ABC 3.UTR Number : XCH34809 Now I need to create a slip design...

Hi All, I have table which have two columns as under, 1. Dispatch Amount 2. WO Amount Now I need a calculated third column as "Difference Amount" I've tried to enter difference formula in "Default value" section of third column but not works. Another option is creating a query. but i am not...

Hi all, I have table name Application which consists of following columns, 1. WO Date 2. TPA Date 3. TR Date 4. Invoice Date 5. Current Stage Now i want to use Case statement to get Current Stage value based on all above 4 columns, For Example, If Invoice Date is null and all above 3 fields...

Hi all, I have a table in which a field name TPADate is set to long text. Now i am planning to make a query design which shows all the table columns in a listbox including TPADate column in it. All other short text columns shows in list box but long text column such as TPADate not shows. Is...

Hi all, I have designed a search data form which has a "Searchbox" (a text box with that name). Now i need to search by a farmer name (a string) or a dispatch date (date value) with the same text box. how can i do that ? thanks below is my query to search Like "*" & [Forms]![View Inward...

HI all, I have data entry form of client details entry. In this form there are two text boxes 1. Client name (Farmer Name) 2. client city This is a data entry form so when i click on save button all boxes will become empty for the new data entry. So to avoid duplicate entries, i have created...

Hi all, I've a table where a column name "Callgivendate". I want to create a query which gives data of current month only. I've tried "Format(Date(),"yyyymm") but it gives me "Data type mismatch" error. How can i get current month data ? Thanks

HI all, I have a table named farmer details, in this table i have three columns 1. App sent date and 2. wo date 3. App sent to wo date diff now i need to calculate date difference between 1. App sent date to 2. wo date and need result in column 3. App sent to wo date diff I know how to use...

Hi all, I am trying to generate data with following criteria in my database, 1. File sent column = is null 2. Status column = Not equals to "return" or Is null 3. Physical file column = Not equals "IN QUERY" here is my query in SQL VIEW, SELECT [App Data].[Regi No], [App Data].[Farmer Name]...