Search results

Pls find the attachment and check the query Net. Why it is not showing Product Mango

Pls wait I upload my database hope you can guide me then

What I wanted I used in form and it works. But in query not working

Thanks for helping. I think you did not understand my means. The only thing I want to show the null values as zero in query which is showing total sum for every product .I showed as a sample above that due to null it is omiting the product mango I have tried your idea but how to link it with...

Can you give idea in detail about union query for this matter. Infact in my example there is no value in whole out table for product mango. While in table have it thus it will show dsum as null and will not show it

I am doing it in query. I am using dsum. I have testing one thing more.if I remove out table then it shows both apple and mango. As soon showed out table again it shows apple

I am trying to make a dsum for products coming in and coming out.pls find the example below Products In Apple 10 Mango 5 Products out Apple 5 Now I want to show statement for sum as follows Product. In. Out. Net in hand Apple. 10. 5. 5 Mango. 5...

Means first it will sort date and then sort by extra field

Ok i will upload it soon so you can see. But in short what i want to show below to Date. Description receipts issued 01/01/2014 sales abc. 0. 10 01/01/2014 purchase 10 0 As you see sales and purchase same date but sales shown first while what i want purchase row to be first

Working like a charm.thanks again

Hi I have made a union query based on two different queries I have made a stock register with date description receipts issued Now i want if receipt and issued dates are same receipts should ahow first Can you give idea how i can do it Thanks in advance

If I used first impression with date written it was working fine

Infact it is not summing at all. Means last expression I used ignoring date criteria but it was giving sum. While now it is giving 0. While it should give result 10 according to data I used

Thanks for helping. Infact it is not giving error but it is not showing correct result. It is returning 0

Hi All I have a form with subform . I want to calculate purchase quantity with criteria of product and quanties before sale date. If i use with specified date it gives correct result.but if i use field address it ignores date criteria Nz (dsum ("pqty","purchasequery","product=" &...

Thanks for help, I have tried, But still the same error Have you checkes SalesM entry and after Sprice update the footer should update, but it gives error of RateofSalestax required, (because it is required in table) May you have tested with existing entry as there is already all entries in...

I did but it gives error for sum function as it suggest sum(expression) no criteria etc

My problem in simple words is : If I make required fields to No in the table then me.recalc on afterupdate event working fine. While if I make them required in the table then it doesnot works with the error requiring the field. So inshort, some method which works me.recalc without...

Hi, I have tried, still not working :(

Thanks for helping Do you mean replacing it with Dsum it will work and requery in afterupdate as you informed above.