It sounds as though you want something like:
=IF(AND(total1=total2,total1=total3),"true","false")
where total1, total2 and total3 are the totals for a particular person from each pivot table. You could get those totals using a "GETPIVOTDATA" function (look at the help files).
Pivot table then, with a translation table and an extra column with a VLOOKUP added to the data each time the .csv is imported. It's more awkward than using Access but will do the job.
From the Microsoft help file:
Create a name to represent a formula or a constant
Show All
Hide All
On the Insert menu, point to Name, and then click Define.
In the Names in workbook box, enter the name for the formula.
In the Refers to box, type = (equal sign), followed by the formula or...
What does the link itself (the URL) look like? Does the URL change, and if it changes, are do the changes follow a pattern? Does the service require a login/password?
I really don't think there is any such built-in feature, and from your description it is not clear how a pivot table fits in.
If you describe what you are trying to do, there is probably some way to program it.
A size in pixels only has meaning for bitmapped images, which an InDesign document is not. Presumably if you know the resolution that is going to be used to display the document (not usually something you have control over), you could calculate a conversion.
What about a 'createdate' field? From the Word help:
Field codes: CreateDate field
Show All
Hide All
{ CREATEDATE [ \@ "Date-Time Picture"] [Switches]}
Inserts the date and time that a document was first saved with its current name, as recorded on the Statistics tab in the Properties dialog...
Table "Heading Rows" is different from a Heading style. Which are you trying to achieve. If it is setting Heading Rows, I believe it needs to be the entire row.
That symptom indicates that files you linked to were either open when you created the links and then saved to different directories, or were originally in the same directory as the linked file and then moved to different directories, or you changed the directory of the linked file.
Excel tries...
Is there a way to force access to keep short date in this field?" is not a meaningful question - there is only one kind of date in a date/time field. If you are seeing it displayed differently than you want, you should explain where and how you are seeing it displayed and maybe someone can help.
Long date and short date are not field types! Datetime is the ONLY type of date field. Long date and short date are display formats and have nothing to do with what is in the field.
Also, it is probably not a good idea to use Date as a field name - that is a word which has meaning in Access
input the time as 4 digits - no delimiter. Then you can use a formula such as "=TIMEVALUE(LEFT(TEXT(B7,"0000"),2) & ":" & RIGHT(TEXT(B7,"0000"),2))" to convert it into an actual time value.
I ran across a discussion of a bug in Excel 2007 the other day on the Woody's Lounge website. The following is Microsoft's posted response to the bug report:
-----------------------------
Calculation Issue Update
Yesterday we were alerted to an issue in Excel 2007 (and Excel Services 2007)...
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.