Recent content by angshubh

My Pleasure!

Right clik on the details area, select properties, set 'Force New Page' to 'Adfter section'. Save it!!

dear dean, i think the problem can be best solved by writing a module where you find the 'square box' in the data and replace is by 'vbCrLf' which is VBA equivalent of line break. I used it in one of my projects so it works efficiently. Convert the data by running the module and store the...

rishi, I dont think that will be a difficult problem, but i need the table structures. One easy way might be to get the current month (range: between date() and date("d" -30)) and the previous month by (range: between date("d" -30)and date("d" -60)). But to provide workable soln, i really need...

On a second thought, julie, I came out with a better soln. Why dont u have 2 tables like patient_master and patient_operation? Patient master will keep all the patients bio-data (!) and in patient_operation table u have patient id and the operation details. now if a paqtient has more than 1...

Julie, Why dont you consider a "Find Duplicate Query Wizard" to get the required result automatically? This wizard will take you thru the process where u only have to spcify the field for which u r seeking multiple entries. This shd be the easiest way. Actually, the solns provided also give...

Thank you very much! It worked perfectly. Great help!!

Thanks for the help. I got the cod, but how to use this? I tried writing a module but it didn't work out. Can u tell me some easier way? Also, actually i posted the question in queries by mistake. My apologies.

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?

Put the Expression in critria area. It definitely works, I've checked. Angshuman SQL: SELECT SubscrptionPayments.Sub_No, [SubscrptionPayments]![EndDate]+30 AS DueDate FROM SubscriberDetails LEFT JOIN SubscrptionPayments ON SubscriberDetails.Sub_No = SubscrptionPayments.Sub_No GROUP BY...

Great!! Halleluah.. it shd have occured to me earlier. Thank you very much Rich! I got gthe answer within 2o mnts of my posting!! Keep it up!!! I'll try to contribute too...

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