Recent content by alisaif

I think I did not convey it properly. I will come again for the same soon. Thanks Saif

Hi, I have one item master file (icode.dbf) which contains around 5000 records. Item codes are like; B1236, W529, H1026 and a lot more. All these items are heavy transaction in stock file (stock.dbf) which contains around 1 million records. If I take records between some specific date, it is...

Thanks Mark, Superb! Saif

Thanks Chriss

Thanks for Mr. Mike and Chris. Saif

Thanks for the hint, definitely I will go through it. Thanks for the time sharing with me. Saif

Obtain last value of running balance of each week. like; Thanks Saif

Thanks Mr. Mark, It is very near to my requirement, yet I need the output like this. How to extract the last running balance of each week. Thanks Saif

Thanks a lot for the reply! I did not test that, but just wanted to show my requirement like this. Thanks Saif

Thanks for the valuable reply! I want like this: Date Style: British Month: June, 2023 Sales from: 1. 01/06/2023 to 07/06/2023 2. 08/06/2023 to 14/06/2023 3. 15/06/2023 to 21/06/2023 4. 22/06/2023 to 28/06/2023 ---------------------------- Rest 2 days separately for 30 days 5. 29/06/2023...

Hi, I want to divide the whole month sales into 4 equal weeks, how can I use SQL to perform this task. Thanks Saif

Thanks for reply! Please check these images. Descr is a memo field. Saif

Hi, Everything is ok, it is saving in memo field, but I want to print the contents of memo field in invoice. It is not printing and showing blank. Thanks Saif

Hi, First time, I am going to use memo field. Please let me know the following: 1. How can I define memo field in cursor define ( create cursor .. 2. How can I display on form. ( Like textbox or edit box.) 3. How can I save it in cursor/table. Thanks Saif

Thanks for the reply! Please find below the code which generates the ledger: Local nbal If ! Empty(This.parent.contAccount.mActCode.Value) This.Parent.cmdprint.Enabled = .T. dt1 = This.Parent.contperiod1.datefromto1._datepicker1.Value dt2 =...