Geting Balance

[pikroausa]

Hey Guys..

I have a problem in a query trying get a Patient Balance but doesn't Work.

Here is the statement:

[Sub-Form Payments].Amount-[Sub-Form Services].Amount AS [Patient Balance]

Thanks for your help...

Pik

 

[boblarson]

And how are you trying to use this? It sure doesn't look like a full SQL Statement for a query and it doesn't look like code on a form.

Please be more descriptive of what you are doing and where.

 

[pikroausa]

And how are you trying to use this? It sure doesn't look like a full SQL Statement for a query and it doesn't look like code on a form.

Please be more descriptive of what you are doing and where.

Here you go buddy:

SELECT [Patient Info].Chart_Number, [Patient Info].Patient_LastName, [Patient Info].Patient_FirstName, [Patient Info].SSN, [Patient Info].Insurance_Co, [Patient Info].Refering_Physician, [Sub-Form Payments].Date_Payment, [Sub-Form Payments].[Check #], [Sub-Form Payments].[Paid To], [Sub-Form Payments].Amount, [Sub-Form Payments].Amount-[Sub-Form Services].Amount AS [Patient_ Balance]
FROM [Patient Info] INNER JOIN [Sub-Form Payments] ON [Patient Info].Chart_Number=[Sub-Form Payments].Chart_Number
WHERE ((([Patient Info].SSN)=[Please Type Social Security Number]));