- value not showing in difference

[prabhu]

In my query, i use to calculate the difference between two fields. like Difference between Qty1 and Qty 2. I use " Difference : Qty 1 - Qty 2 " . But when ever Value of Qty 2 is more than Qty 1 its giving me the result as 0 instead of giving -value. how to fix it.

 

[MStef]

In your table, what is the "Data Type", and what is the
"Field Size" and "Format" Properties (for Qty1 and Qty2 fields)???

 

[prabhu]

Mstef,

thanks for your points. i am new to access, your points solved my issue. i verified those fields and modified, now its working.

One more question, in my Qty 2 column if there is no value its showing empty. is there any way we can get Zero when there is no value.

 

[MStef]

Try to solve this with Nz function.
Look at "DemoDifferenceA2002.mdb" (attachment, zip).
Open Query1, Look at "Diff" or "Diff1" column.

 

[prabhu]

Could you please change it to 2000 version and send it to me. i am using access 2000 and i am getting the following error msg when i try to open u r file < database is an unrecognized format >

 

[MStef]

Here it is!

 

[prabhu]

MStef,

Only thing i can say is "GREAT"

Nz is working in my query. (Diff of ok, Not Diff1) i am really excited after seeing the reults.

Thanks for your quick response.