Access query

Posted on 2011-05-10
Last Modified: 2012-05-11

I have MS Access databases:
DB Clients - ID, Client
DB Orders - ID, Client, OrderTotal
DB Payments - ID, Client, PaymentTotal

In DB Orders and Payments, the column Client is drop-down list from which I can select one of the clients from the Clients DB.

Everything is good until now..
I created query ClientsDuty, which show every client's OrderTotal, PaymentTotal and SumOrderTotal-SumPaymentTotal.. it looks like this:

CHRIS, 480$, 400$, 80$

Now I need to add a button next to all client, which when you click it to show all of the orders that the client made.. example:
When you click on CHRIS's Payments buttons to show:
CHRIS, 60$
CHRIS, 20$

I uploaded a screenshot also.


Question by:QuantumBG
    LVL 16

    Expert Comment

    by:Easwaran Paramasivam

     Could you please more details whare is the front-end you use to develope?

     If it is an ASP.NET application to use the MSACCESS database, then Grid can have button columns by using <Template column> and the Bubble event handling can handle the event in Serverside.

    Please refer below links for more details:

    LVL 77

    Accepted Solution

    Do you have a form that shjows a list of orders (for all clients) - if not create one.

    Then re-do you Show order button, add it again using the controls wizard and this time say that you want to 'open the form and find specific data to diaply'.  You will then be able to link the forms using the client field in the next step of the wizard.

    Author Comment

    Yes, I've done that one time, but it's not showing a list of the clients.. it's showing one by one client and I need to move between them with < and > :(
    LVL 77

    Expert Comment

    I don't understand your response - what is not showing a list of clients?

    This is what you said you wanted...
    "Now I need to add a button next to all client, which when you click it to show all of the orders that the client made."

    Author Closing Comment

    Oh yes yes I didn't understand you..
    It worked now!!
    Thank you so much!

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
    Introduction Hopefully the following mnemonic and, ultimately, the acronym it represents is common place to all those reading: Please Excuse My Dear Aunt Sally (PEMDAS). Briefly, though, PEMDAS is used to signify the order of operations (http://en.…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now