Joining Multiple Rows Into One Row

[Apple001]

Please keep me informed to to your progress. I tested it with sample data. and it worked fine.

ADezii, it works like magic!!!! YOU ARE THE BEST!!! Thank you so much!

I am gonna type what I did in here. I was not sure what "string" data type is, so I just picked "text." I insert the code on form's "On Close" event, so whenever somebody opens the form, save, and close, the table is updated. From there, I created query that calclates dollar amount for each building, and I made label report.

ADezii, why are you so nice to take your time to answer people's question in here? I am just curious.

Again, thank you so much!!! I really really appreciate your help :-) :-) :-)

[ADezii]

ADezii, it works like magic!!!! YOU ARE THE BEST!!! Thank you so much!

I am gonna type what I did in here. I was not sure what "string" data type is, so I just picked "text." I insert the code on form's "On Close" event, so whenever somebody opens the form, save, and close, the table is updated. From there, I created query that calclates dollar amount for each building, and I made label report.

ADezii, why are you so nice to take your time to answer people's question in here? I am just curious.

Again, thank you so much!!! I really really appreciate your help :-) :-) :-)

ADezii, why are you so nice to take your time to answer people's question in here? I am just curious

It's not just myself, but the other Moderators/Experts/Members who assist individuals on a daily basis - it is this environment that attracted me to TheScripts, and it is because of this environment that I'll probably be here until the day I die. It's a pleasure to work with such men and women who donate their time and ask nothing in return. As far as your question itself, I can't speak for anyone else, but for me it is the sheer pleasure that comes from helping others solve their problems, some of which seem insurmountable to them at times.

[Apple001]

It's not just myself, but the other Moderators/Experts/Members who assist individuals on a daily basis - it is this environment that attracted me to TheScripts, and it is because of this environment that I'll probably be here until the day I die. It's a pleasure to work with such men and women who donate their time and ask nothing in return. As far as your question itself, I can't speak for anyone else, but for me it is the sheer pleasure that comes from helping others solve their problems, some of which seem insurmountable to them at times.

Wow...that is awesome. I thought you program for your job. Your comment part on VBA code was very helpful for me to understand the code. Some of the functions in there were not familiar to me, so I looked up reference to learn what they do. I learned a lot from your code. Thank you very much and I hope to talk to you here again!

[ADezii]

Wow...that is awesome. I thought you program for your job. Your comment part on VBA code was very helpful for me to understand the code. Some of the functions in there were not familiar to me, so I looked up reference to learn what they do. I learned a lot from your code. Thank you very much and I hope to talk to you here again!

The pleasure is all mine. If there is 1 trick that I learned over the years, its knowing what specific Function, Method, Event, Property, etc. to use in specific cases. It's a simple matter to reference the proper syntax - knowing exactly what will get the job done is not!

I thought you program for your job.

No, if I had to do this for a living, it would not be fun.

Your comment part on VBA code was very helpful for me to understand the code.

I feel that properly commenting your code is very important in programming, not only for yourself should you need to return to a code segment in the future, but for anyone else who may later need to modify your code. The trick here is to not over comment, this can be nearly as bad as not commenting at all.