Search results

Thank you very much. I really appreciate your time.

I need it, yes. These are unitized values and are all between about +0.5 and +1.9 so I don't worry too much about odd results.

In The Totals function in a report (or a query) you can Group / Sum / Max, Min, etc .... but you can't Multiply. I need Multiply and cant find a work around

OK - so there is no Multiply option in a report for a series of values (same concept as Sum). I have a range of unitized values that need to be multiplied together. Well known issue but I can't find a straight answer out there. Any ideas?

OK - Im new to this so I'll have to read up on it all first. Thanks a lot for the help

DB - thanks - I read that if the queries stay in Access then all the data has to be called from the DB first and then calculated, which would slow down performance. I'll have a lot of data and some complex queries so speed will matter. Is this what you meant by the stored procedure route?

All - i hope you are well. Can anyone send a few good links for a newbie like me to convert my access db to MySQL? I assume the queries should be moved too so access is just the front end. Thoughts and links welcome.

Can I ask one more (and hopefully last) question? I made the change to reference a query instead of table and I'm getting and "Compile Error Expected: End of statement" with the QuantityImpact field highlighted (as below) Here is the new code. All the Query and field names are correct...

Thanks so much... yet again. I appreciate your time

Thanks again for your help. I wrote a load of processes around what you gave me and it is all going well. One question... in MODULE1 - I wanted to change the reference to Table [activityTable] to a Query called [Activity_Prep_NetAllDaily]. The field names and types are all the same. This...

I noticed the most recent date created is 4/1/20 for every position, but the activity goes beyond that. I could not find anything in the code with a limit on the Max date, except for a line you commented out, but that does not seem to apply. Any ideas where I could look? Actually - I think I...

Wow so so so great. 1) the date range is perfect. 2) I see some 0's and Nulls in days with no quantity (1000 / IBM0000 for 12/22/14 and 12/23/14), but I can filter those out. I don't want you do do more work than you have to. Saving me hours upon hours.... TY If I get stuck I'll shoot back...

Arnelgp. Thanks again. You did a lot of work on this and it is appreciated. A few things I have questions on: 1) Can the End (most recent) date be the one business date prior to today instead of the date of the last activity? This is an accounting process, so whatever the End of Day Quantity...

Arnelgp - thanks SO MUCH for this... You just saved me days of my life trying to figure it out, and I probably would have done it poorly. I'll review the code and results in detail and ask any questions, but at first it looks great. Hopefully I wont have to bother you. Really appreciate your help

Thanks for this. I'll try this. My last post added a few wrinkles to my original ask.

Hey PHP. Im really sorry, I'm struggling with this. Your solutions was so very helpful (thanks for all the links), but there are wrinkles I did not figure in. If this takes you too long to figure out I totally understand... I'm always amazed how many generous people are on this forum. I'd...

Of course. Any help is appreciated. TY

PHP - Wow - you are the best. I think these both will work ad I see one has the formula in the query and one has it in code. They both sort of get me to the same results I think - so can you explain why one DB or method would be better then the other? I'll keep reviewing them. The database may...

PHP - thanks for the note, but it is not quite what I need. Those inventory systems give you a net total for the activity for all days' of activity. I need to create an end of day value for each day like a running balance.

All, I'm trying to make Access work like XL, creating data on new rows based on prior rows. Sort of like an accounting system Best to give an example. See the attached spreadsheet I will have Columns A - E in the Table Column F values are what I need to create. See the formulas. A few...