Search results

  1. H

    Sub form autonumber

    Hi all I have invoice with number as master form. In sub form table I want sr.no for all records and I want it to be reset with next master record Can any body give idea how I can do it Example as follow Invoice 1 1. Apple 2.banana Invoice 2 1.banana 2.apple
  2. H

    Fifo batch allocation

    It is working fine. But there is one strange thing. When I use this query it is ok as all products. but when I filter it , it makes issues turn to "d"
  3. H

    Fifo batch allocation

    I think if we use Inner Join can solve the matter, as I just used and it works ok Dim StrSql As String StrSql = "UPDATE (SELECT Sales.Product, Sales.SQty, Sales.SRunTot,sales.sinv,salesm.sdate " StrSql = StrSql & "FROM Sales inner join salesm on sales.sinv=salesm.sinv ORDER BY...
  4. H

    Fifo batch allocation

    @jdraw Can I make sruntot in the example as follows Only difference is that I make master date Salesm with date (salesm.sdate), and I want to use the main form date in it, how it can possibles, (pls note two tables sales and salesm) Dim StrSql As String StrSql = "UPDATE (SELECT...
  5. H

    Fifo batch allocation

    Yes the result is as above. First two records of 1000 are in receipts and other two in issued. If I make union query both values in one column. But I want only these two values in separate column
  6. H

    Fifo batch allocation

    As you see above I want to get purchased and sold are to seperate . As query is union it shows in same column
  7. H

    Fifo batch allocation

    Qty allocation is already I am working.This latest question is also for this as the same qtyallocation I want in different way
  8. H

    Fifo batch allocation

    Thanks for your help. I am already working on this database you supplied. Infact it helped me a lot. Thanks Regarding my 2nd question is just arrive from my 2nd project is to what if we need two seperate values. Can you give idea
  9. H

    Fifo batch allocation

    Update: I have tried union query it works except how I can get separate Purchased / sold thus to write separately on query / report
  10. H

    Fifo batch allocation

    The report which I need will look like this
  11. H

    Fifo batch allocation

    ok, I give example in plain text, Hope you can understand. I have two Tables. 1- Purchases 2- Sales 1-Purchases ( I don't need prices so not mentioned, further I giving example of 1 item for easy ) Date PRODUCT QTY Purchasesfrom 01/01/2014 Apple 100 Pcs Applestore 02/01/2014 Apple 200 Pcs...
  12. H

    Fifo batch allocation

    Ok I will show photo of Excel file then you can easily understand.
  13. H

    Fifo batch allocation

    You can use the suggest file for product A. In a manner purchased sold seperate lines order by date
  14. H

    Fifo batch allocation

    I am also looking the file which you suggested in post #13 Now I have one question. Let's say we want a item history from purchase / sales as below Product name Date. Purchase. Sold. Balance Now problem is that all the date shows in one line from query but I want data in seperate...
  15. H

    Fifo batch allocation

    Thank you , I am looking at it. Thanks for your help.
  16. H

    Fifo batch allocation

    Upto what I understand is to first step to running total of sales and purchases
  17. H

    Fifo batch allocation

    Yes but its very difficult to understand as the developer use non professional approach by not using description. If you can understand the logic pls also let me know as my task if Fifo allocation report on sales
  18. H

    Fifo batch allocation

    Yes that's why I did not understand logic due Pop Sop
  19. H

    Fifo batch allocation

    If you will look my xls you can easily understand what I need result
  20. H

    Fifo batch allocation

    Any solution
Back
Top Bottom