Discuss "Slow Concat Code" in the Microsoft Access forum.

Aww shucks, guys! Thanks! Can I use you as references??

BTW, do you like my new avatar? I'm the one on the left.

Certainly! And the avatar rocks

__________________
jmurrayhead
Did I help you out? Make me popular by clicking the icon!

If you found a post helpful, please click the button in the lower right-hand corner of the post.

Powered by ASP.Net

Thanks. Actually, at this stage of my life, I think the next time I will need references will be for St. Peter! But I'm not expecting to need that for some time yet.

Thanks for your input on this,.. i am still reviewing my options,. but your schema makes sense however, how do you propose adding lines to the order without having to add each part 2x 3x etc to give a total

Thanks DON

__________________
If i helped you, make me famous by clicking the

maybe this will give you an idea or two. I will delve into this later if I get a chance.

Attached Files

Consolidate2.zip (22.8 KB, 6 views)

thanks sbenj,.. we're both on the same wave here,..

I've been trying exactly this for the last hour,. hoping to get the missing lines in,

for example,.. in your sample,.. the first concated request is

Notice how Request Num 18 isn't showing,.. i'm hoping to get also

and a return of all 196 lines.

aha....ok, I will get to this later today.....now I have to build 3 laptop stands..... uggh

So now I know what it's doing..... I thought that might be what you were talking about.

I'm not sure I fully understand your question, but there's no doubt that my approach would require somewhat more complicated table maintenance. My thought is that on a particular purchase order you might have numerous line items for the same vendor, and that, in some cases, the same part number might be ordered to satisfy more than one work order, so those would become separate line items, which is maybe what you were referring to. So a PO might look like this:That's what I had in mind, but I guess I see your point, that you would like to just order a qty of 55 of PN43-Q-11 as a line item. But then, wouldn't you have the problem of knowing what work orders you had purchased the items for? If PO#1234 took 3 weeks to deliver and you had more new work orders that required PN43-Q-11, how would you know which work orders should get the 55 that are delivered?

I'll give this some more thought, but the next few days I won't have time to devote to it.

Thanks Don,... the good news is my tables stucture is almost a replica of your example,.. so theres room for mods,.

It's a shame that the requirements are so specific,. but as it stands i have wrote a new ultra fast concat function which adds the concat to a temp table on the be.mdb ,.. leaving me the problem of the breakdown,.. which is in the last post. Which is required to update the original request table.

I really appreciate your time on this,.. and it must be quite irritating to others as it all seems a little odd.