Combining Detail Items

[eckert1961]

Hello,

I have a receipt report where I am trying to combine the details of a student's order onto 1 receipt. Currently if an order from a student contains 2 different items I will get 2 receipts containing the details for each item. All of the information contained on both receipts is correct but rather than giving the student 1 receipt they receive 2.

What I would like to do is to take the information from the 2 OrderDetailsID, from the same OrderID and combine them into one "Description" on 1 receipt. The information that I would like to include are "Qty", "Size" and "ProductName". The description, on the receipt, would look something like the following.

Qty 2, Size 5, Uniform; Qty 3, Size 6, Belt

Please let me know if you require any additional details or clarification. Thanks in advance.

Regards,
Chris

 

[mykeld]

i am trying to do the exact same thing as u are. If u get the answer please post or private message me. nedd to bring all my fields form my subform to my invoice as well. Thanks in advance

 

[eckert1961]

Anyone????

I've tried using the fConcatChild function from the following link.

http://www.mvps.org/access/modules/mdl0004.htm

When I insert it into a query and run it I get the error,

Undefined function fConcatChild in expression.

I made sure that I entered the function as Public but the result is the same error. Any ideas of how to resolve this error?

Thanks,
Chris

 

[eckert1961]

Any Ideas?

Well, I don't get the "function fConcatChild not found" error any longer. Unfortunately now I don't get any message, the report opens and then closes without displaying anything. Additionally, I don't know what I changed that caused this. I don't have a problem recreating the query but I am not sure how to properly implement the fConcatChild function into my report. Here is some additional information regarding the tables that I'm using to pull the data from.

1) Tables

- Products
- Orders
- Order Details

2) I want to concat the following fields.

From Order Details

Quantity
Size

From Products

ProductName

I've tried using the following syntax in my query design.

fConcatChild("Quantity","Size","ProductName","Long",[OrderID])

Anyone know what I need to change to make this work?

Thanks,
Chris