• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Recent content by JithuAccess

  1. J

    Find sum

    Thanks a lot. It works
  2. J

    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 ID. The actual data is in Excel and I felt it will take few days if i do manually in Excel Thanks
  3. J

    Find sum

    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 values like "Salary", "Commission", and "Bonus" Is it possible to find the sum of these categories by Employee ID. Currently I am doing this in Excel manually...
  4. J

    Joint Property

    It works. I changed my Physician Details table like this: and updates the values: Designed the Query: And this is my Query Result, exactly what I want. Thanks a lot once again.
  5. J

    Joint Property

    Oh So sorry. Million thanks for your suggestions. (y)(y)(y) Thanks
  6. J

    Joint Property

    SELECT [Patient Details].ID, [Patient Details].FName, [Physician Details].[Family Physician] FROM [Patient Details] INNER JOIN [Physician Details] ON [Patient Details].ID = [Physician Details].ID; Thanks
  7. J

    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
  8. J

    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 spent $60.00 but if we are getting a query result like this, then in the report, it will show as $180.00 So could you kindly guide me. Thank You
  9. J

    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 $60.00 but if we are getting a query result like this, then in the report, it will show as $180.00 So could you kindly guide me. Thank You
  10. J

    Joint Property

    Hello Sir, This is my SQL Statement: SELECT [Patient Details].ID, [Patient Details].FName, [Physician Details].[Family Physician], [Physician Fees].Amount FROM ([Patient Details] INNER JOIN [Physician Details] ON [Patient Details].ID = [Physician Details].ID) INNER JOIN [Physician Fees] ON...
  11. J

    Joint Property

    Hi, This is SQL Statement: SELECT [Patient Details].ID, [Patient Details].FName, [Physician Details].[Family Physician], [Physician Fees].Amount FROM ([Patient Details] INNER JOIN [Physician Details] ON [Patient Details].ID = [Physician Details].ID) INNER JOIN [Physician Fees] ON [Patient...
  12. J

    Joint Property

    Hello Guys, I have three tables: Table 1 Table 2 Table 3 I have created a query like this: and I am getting query result like this: And I don't want the duplication. I mean to say I want to get the result like this (Done in Excel): I want to omit the values which I shaded in...
  13. J

    Titles are Not Printing in the Sub Report

    Good Morning Guys, I have created 2 Reports with two Different Data Sources, first one is the summary of the data and the other one is for the details. I want to display these two Reports in a Single Report. So I have created a new Report and created two sub reports for displaying these two...
  14. J

    Align Text Box Verticaly Center

    No Worries
  15. J

    Align Text Box Verticaly Center

    Yes. It looks okay in the report. Thanks a lot
Top Bottom