Recent content by mrszw

Most of what i have came across are base upon a fixed query with fixed number of fields as the base. How can i create a query with a dynamic set of fields. Example, if i select June, the query will returns 6 fields; Jan to Jun But if i select May, the query will return 5 fields; Jan to May

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 am not sure how normalize could this table becomes. The original table before was a 12 cols table detailing the months (Jan - Dec). On the advise of RuralGuy, i "normalize" it by using a union query to transpose the table into a 2 columns table shown below. However, i am still unsure...

sry, the table is meant to be as such i am not very sure about the sorting and dlookup method, because i am not looking for the month with the highest value. What i am looking to do is to identify the latest month that have a value that is not 0. Pls advise if my understanding is incorrect...

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 RuralGuy, could you advise on how do i normalize it? i am wondering how do i use VBA to look through the rows/cols and locate the col/row with value? Something like looping through Range in excel VBA environment, not sure how to go about it in access through

hi, thks for the reply and explaination on the Record Source part. btw, think my phrase ""AA " & Forms!Form1.Combo1 is the exact name of the field in my query" was misunderstood. What i meant is that the word "AA" along with the value of the combobox (Combo1), make up the name of the field...

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...

thanks pabaldy! works great!

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