Recent content by JithuAccess

Thanks a lot. It works

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

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

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.

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

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

Thanks, But I want to find the total money spent by Smith. So we have to include Physician Fees in our query? Thanks

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

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

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

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

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

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

No Worries

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