ChrisMore's latest activity

  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thank you for explaining this. I'm not familiar with coding terminology, such as arguments, but now you have explained it I understand...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    I've added those 4 arguments, the values are taken from the form controls where the intakes are entered. I'm not 100% sure if I've done...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    @gemma-the-husky, I'm off to a slow start unfortunately. I'm getting a compile error (wrong number of arguments or invalid property...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thanks again for all your helpful advice. I think I need to experiment with the code you created in order to understand how best to use...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    I see what you mean now, I refer to 'opening stock' as 'stocktake' and I have a table which hold this data, including a stocktake date...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thanks so much for your time in creating this, I very much like the direction this is going in. I have been racking my brain trying to...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thanks very much for your continued assistance :) I'm happy to also store the ACVO in the products table, that makes sense. But can I...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thank you for having a look. 1. I removed the suppliers table because it wasn't relevant to the sample database. 2. I don't understand...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    @gemma-the-husky have you had a chance to look at the sample database I attached? I appreciate any help you can provide with this :)
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    That's probably the reason DMax didn't work for me then and I had more success with DLast. I have attached a test version of the...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    I'm trying DMax in the new function in the hope that it will work correctly with the loop code. I've made a start with it but as this is...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    I initially tried DMax in the expression but DLast worked better. Not sure why it did but I stuck with it. The expression does exactly...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    I hope I am interpreting your questions correctly in my answers here. 1. The average price is both stored and calculated each time. It...
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    There must be an issue somewhere. As shown in the below screenshot, I have taken away some of the data from the Average_Cost_Price...
    • 1646751631012.png
  • C
    ChrisMore replied to the thread Average Cost Price Function.
    Thanks, I added the format out of desperation to get the code to work. I have taken the format away but the code isn't doing what I...
    • 1646670118635.png
Top Bottom