Search results for query: *

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

HI there, I am running the following query in Access to get a distinct count. It produces the right results however when I try and save the query it crashes access. Can anyone see the problem with it. Regards Mark QUERY SELECT Count(Client_ID) AS CountOfClientID FROM (SELECT DISTINCT...

Hi there, I am trying to return all records less than todays date using... SELECT HitDate FROM dbo.TblStatsPageHits WHERE(HitDate < GETDATE()) ORDER BY HitDate I still get records from today. I assume its because of the time element. ie it returns anything before the date AND time now. How...

Hi there, I have a text field which contains HTML news items. These HTML items contain images and their paths. I would like to extract all the image paths into a seperate field. Can you think of a way to do this??? example: <P><IMG src="http://www.url.com/Assets/Images/News/picture.jpg"...

Thankyou Denny this worked well. As far as performance is concerned we can address this after so any advice would be great. Many thanks Mark

I have a list of people_IDS in a view as follows: 32 74 241 261 289 I also have a list of Other communication ID's (in a view)which relates to the ID of a newsletter. 4306 4307 4308 4309 I want to produce a view that puts a communication key next to each people_ID record. I need it to be...