Search results

numeric to text conversion, amount value I have stored payments amounts like 1875.00 in a column. Now in my report i want to show them as 'One thousand eight hundred seventy five'. How best I can do that?

My table structure is Subscribers Sub_no (primary Key) Sub_name Payments Sub_No(Foreign Key) paymentdate Subscribers.Sub_no is related to Payments.Sub_No as a one-to-many join. Problem I am facing: I want to write a query where only the latest date will come out from table Payments for each...