Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
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...
Mar 23, 2022
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...
Mar 22, 2022
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...
Mar 22, 2022
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...
Mar 21, 2022
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...
Mar 17, 2022
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...
Mar 15, 2022
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...
Mar 14, 2022
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...
Mar 14, 2022
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 :)
Mar 14, 2022
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...
Mar 10, 2022
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...
Mar 10, 2022
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...
Mar 9, 2022
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...
Mar 8, 2022
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...
Mar 8, 2022
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...
Mar 7, 2022
Home
Members
Top
Bottom