JithuAccess's latest activity

  • J
    JithuAccess replied to the thread Find sum.
    Thanks a lot. It works
  • J
    JithuAccess reacted to Minty's post in the thread Find sum with Like Like.
    Do what @Gasman said link to your excel table in access. Then the following query should work SELECT Employee_ID, Sum(Amount) From...
  • J
    JithuAccess reacted to Gasman's post in the thread Find sum with Like Like.
    A few simple SUMIFS() would do it in Excel surely? However why not link to the Excel workbook and then use the query that Minty mentioned.
  • J
    JithuAccess replied to the thread Find sum.
    Sure, This is my Table design: Please note that I have temporary created a table to create a query to find the sum group by Employee...
    • 1596640420601.png
  • J
    JithuAccess reacted to Minty's post in the thread Find sum with Like Like.
    How is your data stored - can you show us the table design? In a grouped query you should be able to use Sum(Amount) if you group by...
  • J
    JithuAccess posted the thread Find sum in Queries.
    Hello Guys, In my table I have fields Employee ID, category and Amount. I have more than 5000 records. In the category field, I have...
    • 1596639745529.png
  • J
    JithuAccess replied to the thread Joint Property.
    It works. I changed my Physician Details table like this: and updates the values: Designed the Query: And this is my Query...
    • 1591196277608.png
    • 1591196302804.png
    • 1591196327898.png
    • 1591196358203.png
  • J
    JithuAccess replied to the thread Joint Property.
    Oh So sorry. Million thanks for your suggestions. (y)(y)(y) Thanks
  • J
    JithuAccess reacted to Minty's post in the thread Joint Property with Like Like.
    Your data tables aren't correct, you would need a table of visits, which should be should have the following ; Without this your data...
  • J
    JithuAccess replied to the thread Joint Property.
    SELECT [Patient Details].ID, [Patient Details].FName, [Physician Details].[Family Physician] FROM [Patient Details] INNER JOIN...
    • 1591194720125.png
    • 1591194738863.png
  • J
    JithuAccess replied to the thread Joint Property.
    Thanks, But I want to find the total money spent by Smith. So we have to include Physician Fees in our query? Thanks
  • J
    JithuAccess reacted to plog's post in the thread Joint Property with Like Like.
    Then there is no need to use Physician Fees in your query. Exclude it and you will get your corect results.
  • J
    JithuAccess replied to the thread Joint Property.
    Hello, Let me explain. Now I will explain you the real problem. I want to find the total money spend by Patient Smith. In real he...
    • 1591194354580.png
  • J
    JithuAccess replied to the thread Joint Property.
    Hi, Let me explain. Now I will explain you the real problem. I want to find the total money spend by Patient Smith. In real he spent...
    • 1591193397183.png
    • 1591194050279.png
  • J
    JithuAccess replied to the thread Joint Property.
    Hello Sir, This is my SQL Statement: SELECT [Patient Details].ID, [Patient Details].FName, [Physician Details].[Family Physician]...
Top Bottom