Hi,
I'm struggling to get the following formulas written. Would appreciate any help.
Number of unique Accounts per Year; I manage to get the unique Accounts but cannot filter per year... =SUM(IF(FREQUENCY(B2:B100;B2:B100)>0;1;0))
Number of unique new Accounts per Year (So Accounts that...
Hi all,
I have a table consisting of 6 table cells (td's). I would like to do the following:
Change the color of a table cell when moving over the cell (onmouseover); change it back to the original color when moving out (onmouseout); and highlight the cell that is activated (after clicking)...
How can I define a space separated list of values for an attribute using NMTOKENS. The values one may use must be predefined!
The below code does not seem to work. The attribute value does not allow for the containment of a LIST of the values; yet appears to be restricted to one value only...
The reason why I am working with section is because the page orientation may vary within the document. So, while text-boxes would solve the linking problem; I would still need sections to control the page orientation. And by introducing the sections, you loose the lock and linking effect of the...
hi,
I have several sections in my word document (let's call them sections A, B, and C). Now, I want to achieve the following:
1) Section B should correspond with a specific page in my document e.g. page 30. As a consequence, Section A always consists of 29 pages.
2) I would like the text of...
Microsoft Powerpoint (2002) has a recolor feature (in the 'Picture' tab of the 'Format Object' pop up). I notice that the 'Format Object' popup in Microsoft Word 2002 does _not_ support this feature. Does someone know, how I can recolor an Object in MS Word?
thanks
j
I would like to add page numbers to my word document, from the fourth page onwards. So the fourth page should start with number 1, and so on...
any ideas?
j
hi all,
How can I change the "tab space after" of the headings that are displayed in my ToC. E.g. the "tab space after" value of heading 1 is put to '1.5', however this value is to high for display in my ToC. I would like to adjust the layout of my ToC independently.
thanks
j.
hi all,
I am puzzled with the following issue; hope someone can help me out...
PROBLEM DESCRIPTION:
I have a first Excell Worksheet (sheet 1) with a list of dates:
[COLOR=red]
(Sheet 1 - Column A)
1 15-May-95
2 16-May-95
3 17-May-95
4 18-May-95
5 19-May-95
6 20-May-95
7 21-May-95
8...
Hi all,
I would like to do the following; hope someone can help me out. I have an input field in a webpage in which I can enter a variable (name="VAR").
Now, by clicking on a href link (not a button!), I would like to pass this variable (together with some fixed parameters) to a...
Hi all,
I seem to have a little bit of a problem with this -at first sight- rather simple query; hope someone can help me out...
I would like to do the following; the query must return a list of records for which the value of the LINK field occurs more than twice in the Access table. For...
Hi,
in have the following table:
author - title - location
In want to have ONE textbox in my report showing the value of the three fiels separated by a comma and TITLE MUST BE ITALIC.
So I could add the followng in the control source of the specific texbox:
=[Table1.author] +...
Hi,
in have the following table:
author - title - location
In want to have ONE textbox in my report showing the value of the three fiels separated by a comma and TITLE MUST BE ITALIC.
So I could add the followng in the control source of the specific texbox:
=[Table1.author] +...
Hi I have the following SQL-statement in MS Access
SELECT TYPE_DEUREN.[TYPE-NR], count ([5_Deuren].[Deur-nr]) AS AantalDeuren
FROM TYPE_DEUREN INNER JOIN 5_Deuren ON TYPE_DEUREN.[TYPE-ID] = [5_Deuren].[TYPE-ID]
ORDER BY TYPE_DEUREN.[TYPE-NR];
I get the error "You tried to execute a query...
Hi,
I have a js file and a html document.
I have made a function which generates a menu onclick
Now I want to put the text which has to appear in that menu in my js-document.
How can I do so (by using document write ?)
Thanx in advance
J
//Start js
var isNS=(document.layers)...
Hi,
can somenone tell me where the "Undefinied" is coming from, when running this script in IE and how I can solve this ?
thanx in advance,
J
<HTML>
<head>
<title></title>
<style type="text/css">
</style>
<script language="JavaScript"...
Hi,
is there anyone who knows if it is possible to influence the position of a Javascript alert box ?
I want the determine the position of alert box dependent on the position of the current html (popup)window.
thanx
j
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.