Search results

That is fantastic, so thank you! (Both of you.) The "direct_linkpart" from my example had snuck in there, but the way you/Duane wrote it made that easy to fix (and also wrap the links around the part nos.). This is a huge help and I appreciate it greatly.

This is more of a "would be nice" so it's low priority, but thinking about how to do it drives me crazy anyway. In Access 2000, I have a database of stories on-line where many have multiple parts, and the part numbers aren't necessarily contiguous. I use a query to generate raw HTML table data...

At least in Office 2000, you can assign a "Workgroup Templates" folder in Tools: Options: File Locations. Our computers all have this set to a shared directory on the server so that new and modified templates are available instantly. If you are distributing them for remote and laptop users, the...

Okay, I made this workbook () so I could double-check my answer, and it seems to work. However, both my answer above and the first worksheet may not be entirely clear because I tried to follow first example's numbers ("total cost for entire quantity using only the expensive option," etc.)...

With some rusty algebra I came up with the following formulas: Qe = (B - Pc) / (Pe - Pc) then Qc = 1 - Qe Where: Qc = Quantity of cheap, as a fraction Qe = Quantity of expensive to purchase, as a fraction Inputs: B = the budget to completely spend ($30 for wine) Pc = Price of cheap per total...