Search results

Hi guys, I have a qry that displays info (see attached) which i then i export to a spreadsheet in excel.I need to add a column within my query to display the total results. Ths formula i have been using is Total_Units...

Ken, My apologies but my formula in xl is actually -I9 NOT 19 (sorry) So it should go as follows =IF(e9=i9,i9*-1,e9-f9-g9-h9-i9) Your suggested way of doing it in access is great it calculates if (e9=i9,i9*-1 but it is not performing the rest of the calculation.

Hi Ken, The first part of the calculation is working fine.Total_Units:iff([Sold] = [NoUnits],[NoUnits]*-1 but if that criteria is not met ,[sold]-[free]-employee]-mamager] is not calculating.The results in the Total_Units is displayiong the same figure from the Sold Field? A little lost...

thanks ken i wil give it a go

Hi Ken, Thanks for your response, i am fairy new to access myself, could you elaborate a litlle more for me on how to build the qry using the function you suggested Rgds T

Hello all, I have a qry with the following fields Ingredients Sold Free Employee Manager No Units I export the results into excel and i have created a column to automatically caluculate the results i am looking for in Column J Sold (Column e in xl) Free (Column f Employee (Column g) Manager...