Search results for query: *

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

Thank you, that did the trick. smigrate is from Portal 2003 but I found an article on Microsofts site that said it could be used in MOSS 2007 so I gave it a try and it seemed to work. A bit fiddly as you've got to create a blank, non-templated site, to receive the migrated content so have to...

MOSS2007 gives you 4 OOTB workflows which seems to work in the majority of cases. If you want to anything clever you'll need SharePoint Designer 2007 which has a pretty good wizard for designing new workflow packages. Tusk

Hi All, I've just managed to successfully migrate a site from our MOSS 2007 test area to production using the smigrate.exe tool. Problem is, the Wiki site is now completely wrong. On the original site, the links page was displayed when you opened the Wiki, now the sit displays as a document...

Hi All, We are implementing MOSS 2007 and I have a question relating to the Document Center and how it differs from a Document Library in a site. Would I be right in saying that a document library in a, say, team site, is for locally stored informaton and that the Document Center is for a...

Hi All, I have created a simple form in Infopath 2007 and published this to the Sharepoint forms library I have created. The form works ok in a browser so no problems here. I want to be able to get the forms data to appear in the teams calendar but this doesn't appear as an item in the data...