Search results

Hi Hitechcoach, thank you for your effort in answering my question. but I think my explaining is not so good, and I finally found something that is what i am trying to do. in this post " Combine multiple rows into one cell " (sorry, cant post link due to my account status)

For some reason, I need to combine some data into one access database. I can think of two ways to do it, but don't know exactly how to do it. hope someone can provide me some advice and suggestion. first, I can send a copy of the database from my office (A) to another office say (B), and when...

Thank you HitechCoach, I think I omitted some information here, actually I have many to many relationship, I normailiesed it in following way, One Order to Many Orderlink, One Item to Many Orderlink. Just wondering if this add more complexity to my original question? and How do I resolve it...

Thanks for the reply. I will try to understand it but for now Im kinda newbie in Access, I am thinking a more entry level way to do it, is it possible to create a query to achieve this? say create a qurey to list all items for each order, then use report or continuous forms to display the...

I need to export order information to spreadsheet in certain format. As shown in following table. How can I combine one to many relationship item with quantity in to one cell? Thanks in advance! Now Order Customer OrderA John Item Qty...