Hello all,

I'm having a problem writing the last line for my where clause for my recordsource for access. I will omit the SELECT and FROM clauses because i know they work.

My where clause works up to this point:
The last "AND" should compare two values from the table deceasedHolder, which are deceasedHolder.[Quantity Approved] and deceasedHolder.Quantity, and return the fields where quantity approved is less than quantity. This is what I put down, but it is generating the error "You cancelled the previous operation.
Any and all help is greatly appreciated.
Mark

Hi,
Try It With Aliases.

you can use this syntax
WHERE deceasedHolder.[Company ID] =@mycompanyID AND AND deceasedHolder.[Next Put Date] = @putDate AND deceasedHolder.[Quantity Approved] < deceasedHolder.Quantity;

and define this variables
define @mycompanyID varchar(20)
define @putDate datetime

set @mycompanyID = Me!Company_ID
set @putDate = Me!txtPutDate

Thank u to every member of this thread. My question is as a beginner in programming, what do l need to understand the programming codes?l have not understand those programming codes and how they are used.