Search results

Calculated Field works for me.

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

Thank Sir, Solve all my queries.. This works like a charm. I was very very confused since last 1 week to solve this and may be drop this idea. But now looking forward. Thanks again

can u please take a look of attached file ? I am very confused in this

Sorry for the late reply everyone. I need to search with date or string (other value) with a single search box and to multiple columns in my database. below is my query code in SQL VIEW, SELECT [Inward Register].*, [Inward Register].[Received Date], [Inward Register].[Name Of Sender], [Inward...

will try and let u know thanks

I have pasted my subform in another main form "View Inward Register" and pasted all code to search button as under, Dim SQL1 As String SQL1 = " SELECT [Inward Register].ID, IsDate([Forms]![Subform TPA]![Searchbox1]) AS Expr1, [Inward Register].[Received Date], [Inward Register].[Name Of...

ohh sorry its TPA data not date. anyway so there is no way to use long text in list box queries right?

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

below is my SQL view SELECT [Inward Register].ID, [Inward Register].[Received Date], [Inward Register].[Farmer Name], [Inward Register].Village, [Inward Register].[Name Of Sender], [Inward Register].Place, [Inward Register].District FROM [Inward Register] WHERE (IsDate([Forms]![View Inward...

Tried does not work

can u guide me how can i apply that in my query as i am new to access

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

It worked, thanks

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

Thanks for the prompt reply. but as per my requirements. i must have to store the values of datediff in a saperate column so that i can export it to excel as and when required. is there any way to do this? 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...

This is the result from Query builder itself. I have not tried to change anything.