Recent content by CresolZim

  1. C

    Filtering To get the Last Revalued amount where ther are multiple revaluations

    Yes I have it . But I thought this would be the same as using the RH_id since it is based on the Autonumber of the Revaluation History . So it should pick the bigger value where there are more that 1 asset ID..
  2. C

    Filtering To get the Last Revalued amount where ther are multiple revaluations

    Hi Folks I have a fixed Assets program which keeps records of company fixed Assets.There is a facility for revaluing the Fixed Assets periodically and the program works fine.Now it has become necessary to revalue some assets more than once per year and the query that reports revaluation...
  3. C

    Emailing multiple payslips to several employees at once

    I think something like that will give me the results I want.What do I need to do to get more details
  4. C

    Emailing multiple payslips to several employees at once

    Thank you. The code Works. The only snag is that the payslip Report has the payslips for all the employees. And this is sent to each employee , and thats not a good idea. I have a procedure for selecting individual employees but this is not appropriate as I have to send each individual...
  5. C

    Emailing multiple payslips to several employees at once

    Thank You for Your Advice and code. Ive tested the code on a sample but the email has blanks. This is my sample code: Private Sub Command0_Click() Dim DBSEmailSample As Database Dim rstPayslips As Recordset Dim prploop As Property Dim Y As String Set DBSEmailSample =...
  6. C

    Emailing multiple payslips to several employees at once

    I have developed a payroll program in Access . I have the payslip report based on a query.Each employee table has an email field. Using the Sendobject Im able to send emails to each employee individually. I need Assistance for a procedure that will allow a individual payslips to be sent to...
  7. C

    Criteria in a DSUM Expression in Query not working

    Thank you!The problem was the Dsum
  8. C

    Criteria in a DSUM Expression in Query not working

    Thank you for your concern.Ive extracted some data to illustrate my problem. Hislines DocType CusName DocNumber tdate StockID STkQty UnitCost DEL jm DEL00024 20/3/2019 Brown Sugar 5000 US$4.00 DEL mt DEL00026 13/2/2019 Brown Sugar 4788 US$2.00 DEL mt DEL00027 4/12/2018 Brown Sugar 1200 US$2.00...
  9. C

    Criteria in a DSUM Expression in Query not working

    Thank you. Let me try it. My objective is to have a single row with the total of stock quantities as openningBalance from the Historylines table This is why Im using the dsum. The problem persists even after I have removed the Dlookup from the date value criteria even after insering the date...
  10. C

    Criteria in a DSUM Expression in Query not working

    Im trying to design a query for an inventory management program .The qury is supposed to give me an opening balance as at a defined period, and transactions in and out up to a defined period. I was hoping to accomplish this by using a union query which will be a union of these two querries A...
  11. C

    Mr

    Hellow Folks Im Keen to improve my Access skills
See more
Back
Top Bottom