Search results

Hi, i have been doing the following function all along using excel VBA, however, the data is getting too large, and i'm now trying to shift it into a access database environment. However, i am having some trouble and would appreciate some help and feedbacks on the viability of this in access...

I have the following table in my access database, how do i identify the latest month with value? I am thinking of using VBA to do a Do until loop starting from the last row, and identifying the row where the value is not 0, after that, i will be able to identify the corresponding month...

Hi, i have got a table with 12 columns (Jan to Dec). In the table, there will be a particular column (month) with values, while the rest are null. How do i use VBA to locate the particular month where there is value? I am currently using a form and combo box to select that particular month...

Hi, i have created a form (Form2) based upon a query (queryA) In queryA, there are two dynamic fields that change according to a combobox value that a user select in another form (Form1). How do i set the fields in Form2 to be dynamic? I tried using the following code, but it generate a...

Hi, i am encountering some problems and need help/suggestions on how to do this transpose. Basically, i wish to transpose the following table but is lost on how to achieve it in excel or using access queries. Would appreciate any help. Original Desired output