Awesome Thanks GSquared!!! this worked out perfectly once I read your post and implemented it properly.

Thanks Again!

Derek

derek.waltho (11/2/2011)

---

Thanks for you reply I tried running this query as you have it changing the table and field names as necessary and it only ever returns the first column...

Thanks for you reply I tried running this query as you have it changing the table and field names as necessary and it only ever returns the first column in...

GSquared (11/2/2011)

---

Okay, here are some questions on this:

1. How does the database know which product comes first, which one second, et al, or does that not matter?

Reply: product order doesn't...