Search results for query: *

Is there any way to exclude cells with highlighted text from formulas. e.g. I have a column with the following values First 1 Second 2 Third 3 Fourth 4 Fifth 5 Total 15 Is there any way to put a formula in the total cell so that cells with bold text are not included, e.g. to give the...

Hi, I have something like the following series of data. A Apples 5 b. Oranges 10 c. Pears 5 d. Oranges 5 e. Pears 10 f. Oranges 5 However, I want to create a chart so that it groups the data and represents it as follows. Apples 5 Oranges 20 Pears 15 Is this possible with Excel...

Again, thank you very much! I got that to work using the following expression. TOTAL: [aug_usage]![Total (Minutes)]+[july_usage]![Total (Mins)]+[sept_usage]![Total (Mins)] Thank you. I have one final question I was hoping you might be able to help with, With the expression above, a total is...

That worked perfectly. Thank you very, very much!! While I’m at it...would you by any chance know how I could create a new field in the query that would be a total of the three months altogether? Essentially it would be a derived field. I was trying to do it doing the QBE but it keeps giving...

Hi, I have a bit of a problem with an Access query. I don't think the solution will be very complicated but I can't quiet figure it out. The easiest way to explain it is to give an example: I have three tables July Usage, August Usage and September Usage, There is only 2 fields in each table...

Hi, I was just wondering if someone would be able to explain the difference between a dsn and dsnless connection using ADO and which one is better to use, thanks, Carol

Hi I was hoping someone might be able to help me. I'm just getting started with all this and things are getting a bit confusing!! What's the difference between a web server and a web application server and how do they interact with each other as well as with as with a database to produce a web...

Hi I was hoping someone might be able to help me. I'm just getting started with all this and things are getting a bit confusing!! What's the difference between a web server and a web application server and how do they interact with each other as well as with as with a database to produce a web...

Hi, thanks for replying, this is what I have, I tried the width thing but it doesn't word, and I can't put a <br> in the link name because it's coming from the database. </td><td><a href=readReview.asp?search=&quot;&jbooks&&quot;>&quot;&rsPrefs.fields(&quot;name&quot;)&&quot;</a></td> Any...

Hi, Just wondering if its possible to get td cells to wrap if they contain a link. I have been trying to get it to work but it seems to be counting the link as one word even though it is multiple words. is there any way around this without creating a separate link, thanks,

Hi, I have created a column with datatype NUMBER(3,8) but when I am inserting values I get an error saying: &quot;value larger than specified precision allows for this column&quot; The values I am inserting are not more than 3 figures to the left or 8 figures to the right of the decimal places...

Hi, I have to pass a username and password as part of my querystring as follows: http://server/report.rpt?user0=user&password0=password. I know that there is some way that you can use the # symbol to hide the querystring but I can't figure out how. If someone can help I would really...

Hi, I want users to be able to download a .pqa file from my website so that when they click on a link they get the option to either open the file or save it to disk. The only problem is I have no idea how to do it, so if someone could offer some advice I would really appreciate it! thanks, cm80

Hi, I am getting the following error and I haven't got a clue why! Microsoft VBScript runtime error '800a01a8' Object required: 'True' /bsci98/cmurphy/ResearchProject/weathertest.asp, line 41 line 41 is highlighted in red below. If anyone can help I would really appreciate...

Hi, I am getting the following error and I haven't got a clue why! Microsoft VBScript runtime error '800a01a8' Object required: 'True' /bsci98/cmurphy/ResearchProject/weathertest.asp, line 41 line 41 is highlighted in red below. If anyone can help I would really appreciate...

Hi, I am new to XML and I was wondering if someone could give me a helping hand parsing an XML document with ASP. I have the XML page loading into the ASP page fine, I just need a hand with referencing and formatting particular elements. For example with the XML document below, what I want to...

Hi, I am new to XML and I was wondering if someone could give me a helping hand parsing an XML document with ASP. I have the XML page loading into the ASP page fine, I just need a hand with referencing and formatting particular elements. For example with the XML document below, what I want to...

Hi, I was just wondering if it is possible to get text to wrap in a text input box, using either CSS or HTML, thanks,

Hi, I am using ASP to retrieve data from an Oracle database and printing the results in a textbox. However when the data I am retrieving is longer than 1 word only the first word is printed. an example might explain a bit better! <td>Address:</td> <td><input type=&quot;text&quot...

Hi chelseatech, I have Crystal installed on NT Workstation. Do you have any idea of any changes I might have to make or is a reinstall required thanks