Search results

what i was thinking is to somehow use the iif function to get the desired result. something like this iif the fiscal year used in the criteria does not exist then use the part id , part description and qty=0 for those year else show the desired result. does that make any sense?

sorry but i am not sure what you mean by striped down version. the databse i am using is huge.

hi go to youtube and in the seach type " Access 2010:auto populate fields using a combo box in forms" it wont let me post link here. i have used this video to acomplish the smae thing. hope it helps.

it is doing that because there is no transaction made in that year. i want to know if there is a workaround that i can use to get the desired result. than you.

sure, so what i am doing here is just to get the sales figures right i only want the transactions that has a customer order id attached to it. then i am using the Exp1 and Exp2 in a way to get the actual sales figures of each part. it works fine and it give me right result. the only problem that...

SELECT Nz([CUST_ORDER_ID],'n/a') AS cust_ord, IIf([TYPE]="O",[QTY],[QTY]*-1) AS Expr1, SYSADM_DEG_FISCAL_YEAR.FISCAL_YEAR, SYSADM_INVENTORY_TRANS.WORKORDER_BASE_ID, SYSADM_PART.ID, SYSADM_PART.DESCRIPTION, IIf([cust_ord]='n/a',[Expr1]=0,[Expr1]) AS Expr2 FROM (SYSADM_INVENTORY_TRANS INNER JOIN...

hi i just attched my query. so if you see in the query i am pulling all the sales record that i have since 2007.

hi everyone, I am using a query that will show me the sales figures. basically it shows me how many of each part i have sold in a particular year, my query works perfect for that. Now What i want is let say there is a part no that we have not sold at all in 2011. so my query return me with all...