Recent content by douggy

I have a spreadsheet which outputs an invoice. The invoice has two separate totals at the bottom. 1 for Zero VAT rated goods and 1 for Standard VAT rated goods. I need to sum the zero rated cell where VAT rate against an item = 0. Can anyone help Thanks Mark

hi there, how can I alter this query to force two decimal points in the resultant figure. Margin: IIf([Margin Value]>0,[Margin Value]/[Sales Value],0) I can do it by setting the field property in the query designer, however I want to force it in the query. Is this possible. Thanks Mark

Thanks both of you. Great help. Dhookom, can you just explain in a little more detail how I format the property of a text box. Thanks Mark

I have a field which displays the result of a calculation. The field is based on the following: Stock Turn VOL Weeks: [Stock Volume]/[Sales Volume]*52 I want to adpat this so that it performs this calculation if the field [Sales Volume] is greater than zero. Otherwise I wish to insert the...

Hi there, I have to convert the following number format to a date. ie something I can query on for where a year month between x and y. Number is in following format "200801" YYYYMM Thanks for your help in advance. Mark

I need to add up the stock quantities by row so my resultant query adds up 49 and 41 (eg the first line of my example) and adds a column containing 90. Can you help? prd_rcn | prc_stkqty(1)| prc_stkqty(2) 52 49 41 52 26 17 52 20 32

Hi there, I have small business server 03 running. Within exchange there is a Distribution group called 'Sales'. This has one member at the moment. To the outside world the address is sales@company.co.uk. I need to be able to foward external emails that come to sales@company.co.uk to another...

Word, Excel etc all seem fine

I have just installed Acrobat Reader 9 on a Win XP pro machine. All was fine. However pdf docs are not automatically recognised. ie the user has an email with a pdf attached however it does not open with Acrobat Reader. Any ideas why this would be happening. Regards Mark

Is there a way of logging onto to Small Business Server and getting a report on the internet history for a particular user?? Thanks Mark

Hi there, I have a windows copy command setup as a scheduled batch file. It takes one xml file (a text file) and overwrites one of the same name in a different folder. It has been working fine and all of a sudden it still seems to perform the overwrite but the new file ends up being truncated...

Hi there, I have a string in a field which contains a document path. example: ~/User/Documents/TGEACASE.PRT I would like to extract just the file name. i.e everything after ~/User/Documents/ Any pointers on how to do this would be appreciated. Regards Mark

Hi there, Our site creates the following URL which does not work. I think its because of the double ampersand. So it can't see the ItemId=13555. Can anyone help. Thanks Mark...

HI there, Can you help me with thh SQL to return all records (Company Name Field) that have leading Spaces. Kind regards Mark

How to I select everything before the first space in a string. ie if there is a companyname field containing Smiths Joinery Ltd I only want to return Smiths Regards Mark