ChrisMore's latest activity
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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 :)
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
CChrisMore 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...
-
-
CChrisMore 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...
-
