Search results

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

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

It really works Rookie... You're right we have to replace into [Patient Info].Last_Discharge_Date+90 AS [Next Visit Date]. Thanks Husan, Rookie and everybody for your help... I'll be in touch to help other people with the little knowledge that i have... Thanks Again....

Here you go buddy!! SELECT [Patient Info].Chart_Number, [Patient Info].Patient_LastName, [Patient Info].Patient_FirstName, [Patient Info].SSN, [Patient Info].Phone, [Patient Info].Active, [Patient Info].Last_Discharge_Date, [Patient Info].Next_Visit_Date FROM [Patient Info] WHERE ((([Patient...

Ok.. Let's start again... I have Last_Discharge_Date, and I want to put into Next_Visit_Date a date 90 days from Last_Discharge_Date. I tried Dateadd on Next_Visit_Date but doesn't work. ie: DateAdd("m",3,[Next_Visit_Date]) I really don't know how to figure it out...

Thanks Husan.... They show me an error: Date type mismatch in criteria expression.. Thanks again

Thank you for your answer. That happened is I'm feeling frustrating with this. My apologies if I offended anyone. I'm just want help, because nothing works in any way. If it is any help here is a couple of pics of the query. Thanks again!! Angel

But Where?? On first field or second field in a query?

Shows Blank Buddy!!! Both are date types.... in a query (not update) Thanks!

Thanks for your answer! But where I have to used? on Last_Discharge_date or on Next_Visit_Date? Please if you can write the whole criteria, I gonna appreciated.. Thanks Again!!

Hi Guys!! I have a big problem.. I have a date that I need ad 90 from that date. Last_Discharge_Date + 90 days into Next_Visit_Date How Can I do That? Pleaseeee HEEEEEEEEEEEEEEELLLLLLLLPPPPPPPPP!!!:eek::eek::eek::eek::eek::eek::eek::eek::eek: Thanks Guys!