I am stumped! I have 3 fields. Reorder_qty Maintain_qty Physical_Count This is what I have written so far. Qty_to_order: IIf([physical_Count]<=[Reorder_qty],[maintain_qty]-[Physical_Count]. I basically want the query to give me a total of how much to order when the Physical count is less than or equal to the reorder level. But it needs to generate the difference between the maintain qty and the physical count. What am I doing wrong?