Thank you for your response. The numbers in total are arbitrary. I just put any numbers. Because I have many fields I did not put all of them. But you are right the total for first row should have at least 3. Ok, I know how to transpose (union all) but is there a way to transpose using loops...
I am sorry if my question was not clear. I do not create tables or add new records to them. I get excel sheets and I import them in access. I am looking for a Vba code to loop through the records across the fields.
I have a question related to this code please : Len(“”, me.searchbox), what does it mean. I understand all the components of the code but I am trying to put all the pieces together to interpret it correctly. It is a part of the following code , if Len (“”, me.searchbox) = 0 then do something...