Search results

  1. I

    Copying data

    I have an Access database that has been in full swing for a few months. Another copy of the same database I have been updating and improving. My issue is that I have converted a couple of fields from text to a lookup. I can't copy the existing data into the new database due to the field change...
  2. I

    Sub Report in a Form

    I have a "Stock Check" report that has a running sum and has a filter attached to it. Works perfectly. I also have a form that allows the user to adjust the stock level. What I want is to put the report as a subreport into the form, so the user can see the current stock level. I have the...
  3. I

    Running Total

    I don't understand why there would be one record per group. If I group by product that product would have numerous "Goods In" and "Production" data to create a running sum. At the moment I have it working for all products, but I want to be able to filter it to one specific product to check on...
  4. I

    Running Total

    Ok, Just to throw an absolute curve ball into the mix here. I have realised I can do a running sum in a report that will work with a filter in the query. The only issue is it doesn't work with [Qty] but will work with every other field such as GoodsID. Why does Access hate me so much?!?!?
  5. I

    Running Total

    It is only sample data I have put in, so can add more data to get the running total. Where would I add the "product" to the summing criteria for it to group by "product"? RunningSum: Sum((Select Sum([QtyAdjusted]) from [QCombinedInventory] as a where...
  6. I

    Running Total

    Stage 2!!! Do I put this under a new topic or is it ok here? How do I group the query with a running sum. When I filter the data by product, it still running sums the entire datasheet rather than what I am filtering.
  7. I

    Running Total

    Don't go away Gasman, we have stage 2 - stage 20,000 to complete yet!!
  8. I

    Running Total

    Stage 1 of the mission complete. Because a few products can be used in the same production batch it obviously gives them the same Timestamp. My REALLY UGLY work around was to use the GoodsID number and turn that into seconds. Then add that to the Timestamp. This meant every Timestamp in...
  9. I

    Running Total

    I tried looking at putting an autonumber ID on, but strugglued because the query is getting its data from the "Goods In" table and a union query containing the production data.
  10. I

    Running Total

    Yes, I am trying (and failing to crawl before I can run.) In an ideal world, I want it to add the "Goods In" and then subtract the "Production". I also want it to reset when a stock adjustment has been made. I just thought it would be easier to figure out how I could get a running sum to work...
  11. I

    Running Total

    Hopefully I have attached the data I am getting. It actually looks like it is adding up the "Goods In" data ok, but when the "production" data is added it throws it out. Maybe formatting on my production table is incorrect. Lets investigate!! (Sorry, I really need to stop watching Noddy the...
  12. I

    Running Total

    Hi Gasman Thank you for your patience with me on this. The end of my SQL does say ORDER BY QCombinedInventory.Timestamp;
  13. I

    Running Total

    Struggling to upload, but I will try again when I get home from work. I have tried this statement. Runtot: (Select Sum([Qty]) from [QCombinedInventory] as a where a.[Timestamp]<=[QCombinedInventory].[Timestamp]) I get numbers, so a sense of achievement has been reached, it is just they are all...
  14. I

    Running Total

    I cant get it to work in the report running sum either. Control Source = Qty Text Format = Plain Text Running Sum = Over all Enabled = Yes
  15. I

    Running Total

    I am trying to get a query to give me a running total....and failing miserably. My select query is getting it's data from a union query (QCombinedInventory) and a table. (Goods) I want a running total of Qty. I have scoured the internet and have now lost the will. This is what I have at the...
  16. I

    Union Query & Combo Box

    The query solution worked, thank you. I just had one combo that I could add multiple values. Then realised I couldn't union query on a multi value combo box.
  17. I

    Union Query & Combo Box

    Good afternoon I have a union query which is getting some of its data from a combo box result. Within the union query it is stating the First column rather than the second column. The data in the table does state the second column as I want it to do, but I can not get the union query to follow...
  18. I

    Query resulting in 556

    Ok sorry guys. I have just figured this out. For whatever reason, if I remove the word "sum" it works in this query, but not the other. Oh well, i'm sure i'll be in touch soon!!!
  19. I

    Query resulting in 556

    I'm back again and going insane. In a query I have Sum([Convert]*[Quantity]) [Convert] is a weight and [Quantity] is the quantity of labels needed. In another query this has worked perfectly, but in this current one it is already multiplying the quantity by 556. example: It should be...
  20. I

    Revove decimal if two in field

    Once again, thank you very much. Worked perfectly.
Top Bottom