Search results

  1. D

    Solved Serial number in Alphabets in MS Reports

    I want to assign serial number to each record via property>data>=1 overall. Its OK and serial 1, 2, 3 etc. However, I want to serial number alphabeticlly i.e a b c d and so on. I did this once in past using CHR(97), ASCII 97 represents a 98 represents b and so on. Unfortunately I could not...
  2. D

    Refering Parameter criteria from Forms to crosstab query

    I have few cross tab queries in my database. I wanted to get results in cross-tab basing on criteria from a combo on the form. If I have a fix value that works but if I execute query after having passed criteria from a combo on a form, it does not not work. Looking forward for guidance, please.
  3. D

    How to count records on each page including the count of all previous pages

    please what did you do with the report, where you added any event builder. and how can I apply to my real database Regards and best wishes You and arnelgp have always helped
  4. D

    How to count records on each page including the count of all previous pages

    Dear All, may you live long. Example:- I have 20 records on page#1 and 21 records on page#2. On page#2, i want to show count of total records that is = 41. Similarly I have 9 records on page#3 and on the bottom of page#3, I wanted to show count result as 50. Regards and best whsihes
  5. D

    Solved Calculate previous record in current Record

    Third record's result is wrong. It should be multiplied as [New Pension] in previous record * 15% and add [New Pension] of previous record. Here I attached result with manual calculation in 2nd last column. DeptNo CNIC Relationship Percentage Pension new_pension Correct Value Reason...
  6. D

    Solved Calculate previous record in current Record

    No criteria for grant of pension. Its granted manually once government announces. We have one figure thats say 660. Once an increase is granted say its 10%, then calculation = 660*10%+660 against that record where 10% is entered. Generally previous record is calculated with the given value and...
  7. D

    Solved Calculate previous record in current Record

    Great. May I have your whatsapp no. In fact i want some more guidace please
  8. D

    Writing Multiple criteria in DSUM function

    People in the forum are very cooperative. Your assistance can ease people to a big extent please. Keep it on
  9. D

    Solved Calculate previous record in current Record

    I am using a Db for calcualting pension. Pension is admissible on gross pension and then increases are added in gross pension. Every increase (percentage) is added in previous record and shown in current record. I am attaching the db as well illustrated the same as under: Gross Pension : 660...
  10. D

    How to make page footer invisible on last page of the report

    Thanks all of you for response. i got it.
  11. D

    How to make page footer invisible on last page of the report

    Thanks all of you for response. i got it.
  12. D

    How to make page footer invisible on last page of the report

    I have attached a file. if you can help
  13. D

    How to make page footer invisible on last page of the report

    Thanks for your response. I am attaching a file. If you can kindly preview the report and see page footer and report footer. On the last page of report, Page footer should not be visible pleas Regards
  14. D

    How to make page footer invisible on last page of the report

    I have a report having multiple pages. The report has a report footer and page footer. I want not to preview pager footer on last page i.e alongwith report footer
Top Bottom