Recent content by ryshkus

Is there someway I can get this to print in a report form?

You are absolutely amazing to me. You have no idea how much I appreciate your time and effort in this! Wow! I am speechless. Thank You So Much!!!! Stacey

I only wanted the report to show active status.

It worked, but it shows me everything.

That worked.

Is there an easier way that I should be doing this? Basically I need to be able to show that either the company paid or that we wrote the difference off.

It still shows no results. I even added a few dummy entries to make sure the result would be something.

SELECT [101504].Date_Ent, [101504].File_No, [101504].Caption, [101504].Resp_Atty, [101504].Invoice, [101504].Date, [101504].Amt_billed, [101504].Amt_paid, [101504].Amt_due, [101504].Later_pay, [101504].Reason, [101504].Res_Date, [101504].Res_Amt, [101504].[W/O Date], [101504].[W/O_Amt]...

This is all I have. I don't think I have any SQL code... IIf(Nz([W/O_Amt],0)+Nz([Amt_paid],0)+Nz([Later_pay],0)=[ Amt_billed],"Inactive")

If I leave Nz, and take out the last ) after Amt_billed] I get a prompt to enter a value. No matter what I enter I get no results.

Does Nz refer to the database name? I replaced the Nz's with the database name, and then I get an error that points to the first ( after the first Nz. Why the ,0? Thank You for your help so far!

Still shows nothing. I have added the write off amount field, so everything should show when I run this query. I only want the fields to show that the 3 fields added together don't equal the last. Stacey

Hello, I am trying to figure out how to do something with our accounting DB. We bill a customer. They pay a certain amount less than what billed. I need to take 3 fields and if they equal the write off amount billed field then I want them to go to inactive status. This is what I have and...