Search results

Hello Plog, I've managed to plug the code on VBA but the Remarks are not filtered per Chartline. I know I am missing something but I cannot figured out how to use the "Filter" part of the syntax. Appreciate your checking again. :) Cheers,

Oh my, :confused: but it must be in a single field also. Can you help?

Hello Plog, This is amazing :) :) Everything that I need is here! There is one more thing, how can I managed to build a query out of that Variance Table that produces the Variance Increase/Decrease explanation. It will be something like this (since it now calculates the difference between two...

Hello Plog, Ok, apologies. Can you check if I made the right Totals Query? I attached again the file and combined the two excel sheets. Cheers,

Hello Plog, Thanks for the quick information. I somehow managed to create cross tabs. These two cross tabs produces the sum but only for a specific chartline (as the other chartline serves as a separate Cost Center, but we con focus on this initially). But then how can I create an increase...

Hello All, Is there a way to replicate NETWORKDAYS formula in Excel to Ms Access? Maybe a sort of macro? Cheers, Vash

Hello Plog, Thanks for immediately replying my query. It is very much appreciated. :) :) I separated these two data because they are coming from two time periods. The first table is for 6-2015 and the other one is for 3-2015. The Chartline serves as the Mainline (something like Expense)...

Hello All, I am trying to create a Ms Access database that will generate an automatic variance explanation comparing two periods in two tables and the comparison in third table. This will help me eliminate the time spent on tedious (manual) comparison of various increases and decreases between...

Hello To All, Thanks for the wonderful welcome. :) :) I am sure I'm gonna enjoy my stay here. I am from Philippines and currently doing some projects related to Ms Access database. Looking forward for a lot of learnings. Thanks. :)