Recent content by Tusk

Yes, I did include the WHERE statement as supplied, and I did adjust this for my setup. I have to admit to deleting the original query as it didn't seem to work for me :-). I will rebuild it again using Remou's solution and provide the necessary information to this post.

Doesn't look so bad really, client is happy to go with it for now. Cheers guys.

Hi Remou, Had a go with the numbers table. By the way this seems to work, the numbers table will need to be reset for each order line, not really what I had in mind! I tried the code you posted, editing the query to fit my tables. The query runs and asks for the productID, which I give (one...

Ok I think I can see where you are going with this. Question, where does the numbers table come from and what should it hold as fields or data?

Hi Remou, not sure I understand what you are getting at with this? Where does this go in relation to the report? I have a customers, orders, and orders detail tables. The orders detail table holds the order ID, product ID, and quantity ordered. What the client wants is to be able to run a...

I have a label report that prints out address labels for customer orders. This all works just fine, however, the client wants to have a separate label where the quantity is more than 1 i.e. product = Blue Widget, Quantity = 2; This should generate 2 labels for this customer. Any ideas of how to...

Thanks both, will try and see what happens :-) "BTW: is it so bad to have the name an address side by side?" Well yes in this case it is, space is limited and it's what the client wants :-) Cheers for the assist so far. Tusk

Hi All, I have a combo-box on an orders form that returns customer name and address data from a linked query. The combo-box returns the correct data but I want to be able to format the output so that the name and address appear on different lines in the combo-box. Is there an easy way to do...

Have solved my own problem :-) Simple really, trying to be too complicated! =IF([Risk Score]>11,"HIGH", IF([Risk Score]>7, "MEDIUM,"LOW")) That does the trick.

Hi All, I'm trying to construct a list in MOSS 2007 to track Risks. Part of this is to calculate the risk score which is ok, but the next bit is proving tricky. I want to be able to allocate a High, medium and Low to a status column depending on the risk score. I can get it to do a 'medium' and...

As a supplemental question. Is it possible to access this information and display it in the Document Library view as a column? Tusk

hi Dan, Found this which might help "One of the new features in Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 is the ability to extend a document library to support multiple content types. (Content types are groups of settings that you can apply to a category of...

Thanks Greg, So simple it hurts :-) Tusk

All, How do I change the default font in the default document type in MOSS2007? Thanks Tusk

Hi All, Anyone an idea how to display the sizes of document libraries in MOSS2007? I have a need to track the growth of document libraries. Cheers Tusk