Recent content by jrsaturnino

  1. J

    Created a Query but got duplicate Results

    Thank you Pat. But how can we add the sales from Forbes Academy to qryARBalance considering this is new transaction and will pay after 15 days. Please help me. thanks
  2. J

    Created a Query but got duplicate Results

    Dear smart people, Salamat kabayan! for tips and helpful changes in my database. I made some queries (qryARBalance/qryDueForCollection and Etc). I tried to add a sales from Forbes Academy but the balances of those queries mentioned remained the same. It should increase by 900K but did not work...
  3. J

    Created a Query but got duplicate Results

    June, Thank you for the comment and suggestion. I like the option 2 that you just gave me which shows the sub-report, can you help me how to do it?
  4. J

    Created a Query but got duplicate Results

    Thank you Pat! Your suggestion has bee effected. but i found difficulty in merging payments into one payment when customer pays in partial. In my query, in relation to roberto saturnino transactions in his second payment TotalRevenue should not be duplicated/ or should be excluded from...
  5. J

    Created a Query but got duplicate Results

    Good morning smart people! I hope one of you can help my current issues that i am facing with MS Access. The situation is i made separate tables for Customers, Sales and Collection. Then when i created a query from those tables i got duplicated results. I was expecting by obtaining the...
  6. J

    Need some serious help

    Hi Mark, Can you help me with this ms access. I am new to Ms access, basically my ideas came from this forum and other video materials. I want to have an automated MS access Ledger. I want to have the following functions/features in access: 1. Sales Report - Where i can search sales by...
  7. J

    Need help with ledger db query for monthly reports

    I hope there is someone from this can help me out with our problem. I want to a system from Sales Order, sales, billing, collection and posting of payment to the ledger.
  8. J

    Need help with ledger db query for monthly reports

    I have the same problem. I am trying to convert our manual ledger into Ms Access. But i dont have much experience with access. I am still learning the process through video materials and this forum.
  9. J

    Audit Trail

    I am just new to this website however i found this website very useful for a beginner like me. I am working a simple Subsidiary Ledger for my studies and i think a piece of advise from you guys would help me improve. Here is my problem, i want to track down all users log-ins and the changes made...
Top Bottom