Replies

Sorry about that, I have attached a copy of the file. Thank you

Post deleted by jgellert2222

Thanks for the help. The original code is working great and will do what I need. Thanks again

Hans,

That worked perfectly.

Could you also tell me how to paste a screenshot? The pasting of text works perfect but of course it will not work for an image. Any suggestions?

Thank you for all the help. It worked perfectly.

Cheers

Steve,

This works very well. Thank you for the breakdown on the formula. It is very helpful to see how it is built. Thanks a million..

John

I do have Access 2003, but my experience is VERY limited. I have created a new db, imported data from the excel file, created a table and but am stuck on the crosstab query. All I keep getting is the list of product number and a very wide report showing data I don’t understand. Could you help with the steps on the crosstab query?

Thank you Mbarron, HansV (you are always a huge help), and thank you Sdckapr- I did not know the autofilter trick either (a bonus for the day).

Thanks again,

Hans as always you are a GREAT help. I have made the change and it works great.

Thanks a Million

Hans,

Greatly appreciate your help, it worked perfectly

John

Hans,

A million thanks, I worked a little bit with the F1 help and some of MS Excel info this morning, thinking that Index was the way to go, but I would have never gotten this far.

Thank you again,

John

Legare,

Thank you very much, this has saved me a ton of time and has given me a more reason to crunch more numbers.

Thanks a Million

Lee,

I am not certian as what you are looking to gain from Outfront and unfortunately I have no dealings with them to give you much feedback, however, I have designed many sites from personal to professional and there is always one thing I try to keep in mind. If it is my personal website, and I don’t care that is is being supported by a teenager from Texas WITHOUT a support phone number or a live body I can talk to when they don’t flip the FP extensions– then by all means go with the cheap hosting companies. However, if you want support, and you want to save a lot of frustrations when things go wrong–because they will, then pony up the extra money and go with a hosting company that gives you what you pay for.

Personally I do all mine through Dreamworxhosting.com. Talk to Jim he will hook you up.

Lee,

I am not certian as what you are looking to gain from Outfront and unfortunately I have no dealings with them to give you much feedback, however, I have designed many sites from personal to professional and there is always one thing I try to keep in mind. If it is my personal website, and I don’t care that is is being supported by a teenager from Texas WITHOUT a support phone number or a live body I can talk to when they don’t flip the FP extensions– then by all means go with the cheap hosting companies. However, if you want support, and you want to save a lot of frustrations when things go wrong–because they will, then pony up the extra money and go with a hosting company that gives you what you pay for.

Personally I do all mine through Dreamworxhosting.com. Talk to Jim he will hook you up.

I am looking at a way to create a pull down menu that appears somewhere else on the page, activated by a mouse over. If you wouldn’t mind, please check out http://www.princess-kaiulani.com/ and reference the right hand side where it gives you Dining & Ent., Activities….etc. You will see that on a mouse over it gives you this floating box below the list of buttons. Thank you for your assistance.