Search results

If there is a lady customer, who is enrolled by her maiden firstname, middle name and last name. She has a unique national number or ID Now, after marriage her middle name and last name will change. Or even after her divorce she re-marries the again her middle name and last name will change. At...

Thank You Sir Getting expected results

Sir this function is giving results correctly. But can we make it default 1st of that month

Is there any formula to calculate approximate birth month and year in the format of 01/mm/yyyy from approximate age in year and month. e.g. if someone gives age as 10.2 years, then what should be the approximate birthdate as on today.

Yes Sir it is showing the data with some wrongly typed (by mistake whle doing Customer Id update manually) Customer Id in Visit table. Sir now how can we Update the Customer Id in all matching rows in Visit table Sir one more thing There are total 5771 rows (visit number in Visit table) and the...

I tried your way Sir, bbut with no output Sending the zip file Please help

Sir Can you help me with the function creation

Sir it will only replace the word. On the contrary I dont want to delete any other last word other than "dsead" I want to keep the other last words e.g 4896, 92hn which are <> dsead

Sir I have a string field value in a column Place in Place_tbl, for example 123, abdf, sygea, dsead kasr, dladr, ase, 4896 2123, abdf, sygea, dsead 523, abdf, sygea, dsead 93, abdf, sygea, dsead 125, csd, edrf, dsead sdfg, 124, jkf, 92hn if I use the query shortenedPlace...

Sir, How to put the CustomerID which was not inserted in the related another table to the customer table. e.g. I have one tables Customer_tbl And I created a Visit_tbl where I update the data using a update query using the Customer Name Initially I had not inserted the CustomerID in the...

Sir none string will be Null or there won't be a string without comma

Thank You it works

Sir, I have a string field value in a column Place in Place_tbl, for example 123, abdf, sygea, dsead or kasr, dladr, ase, 4896 I want the result without the last word 123, abdf, sygea kasr, dladr, ase What should be the query design Please Help

Thank You Sir Getting all the expected results

Sir actually I require a total count of rest other than Jalna

Thank You Sir A last doubt There are total of 33996 records in Place_tbl How to get the aggregate of other places in the table with a parameter of <> "Jalna"

Sir I found that I had named the module with the same function name Corrected it gave result. Sir now how to get the count of the second last name

Sir sending the sample database. The above function is in separate module. Also Sir wanted the count of value obtained

Sir, as I am trying to use the the above function in a expression, it is showing error I tried this piece of expression "SLV: SecondLastValue([Place])"

Sir I require the second last values