Count distinct days from two groups of days
Can anybody help please?
I have used Networkdays() to count the working days between two dates. And
have had to do this twice. So now have two counts that I will add together.
But if the same particular date is in both count sets I dont want to count
Hope this makes sense,
Thanks in advance
On Tue, 16 Feb 2010 19:51:01 -0800, Colin <Colin@discussions.microsoft.com>
>Can anybody help please?
>I have used Networkdays() to count the working days between two dates. And
>have had to do this twice. So now have...Microsoft has removed 500+ groups, including 21 Windows-98 groups
I'm not exactly sure when this happened, but Microsoft has removed
approx. 535 groups from it's server. 21 of those pertain to windows-98.
Those 21 groups are:
microsoft.p...resource usage 01-13-10
Is it possible to display remaining work in the right hand Pane? I can
display it in the left hand pane (the table section) but can't seem to
find in the right hand pane (the timephased area).
eg. I want total remaining work for each resources for each month
lk50's Profile: http://forums.techarena.in/members/87282.htm
View this thread: http://forums.techarena.in/microsoft-project/1292777.htm
Nope. Remaining work is not a time...CListView + grouping + tiling = ????
does anyone have an example/sample of using grouping and tiling in a
I'm buggered if i can get it to work.
...about resources and the using
GC removes objects when the GC decides so because C# is managed.
At the bottom I have a code snipped.
The book I read say Always call Dispose() on Pen objects or use the using
feature on the Pen object.
I mean C# is managed so I can't understand why I should dispose the Pen
object. GC should take care of this.
The reason is probably that I mixup memory and resources. GC take care of
free memory but not resources.
I have some problem to understand why I must dispose the Pen object here
because I see the Pen object as
any object such as a Person or Car.
So my first qu...MCSD Resource
I have found a resource providing answers for examination questions
being helpful in certifying for MCSD....
In my report I have it sorted by Category.. My categories are 1 - BBH, 2 -
ABD... all the way to 15 - Repairs. When it is sorted its 1 - BBH 12 -
Housing 13 - Fuel... and so on. How can i make it 1, 2, 3, 4... ??
Message posted via AccessMonster.com
That still didnt work... Any other suggestions? Thanks
Duane Hookom wrote:
>The report is sorting as designed. You might try change the sorting and
>grouping expression to:
>> In my report I have it sorted by Category.. My cate...Query-Based E-mail Groups
I have created query-based email group that contains 1,600 users. When I
send an email to that group, about 350 users don't get the message. I as the
owner of the group get an undeliverable stating:
The e-mail system limits the number of recipients that can be
addressed in a single message. Send the message multiple times to fewer
recipients. For all 350 users.
So I check my "Message Delivery Properties" in ESM. I have my "Recipient
Limits" set to 2,000. I double checked the query-based email group to make
sure it was under 2,000 recipients and ...Catagory/group other than expense or income
I am using Money 2004 to pay bills for a homeowners association. Simple, but
it is working fine. I do have one problem. When a homeowners check bounces,
the money is then removed from the bank account. There are no fees incurred.
When i export the bank statement, money places that transaction into the
"expense" catagory. I want to keep track of these, but they are not truly
expenses. It seems that money only has two options income or expense. Can i
set up a catagory or group that is neither an expense or income?
In microsoft.public.money, bobteriw wrote:
>I am using Money ...Test on Type in Resource Center
In Project Server 2007 SP2
In the Resource Center of PWA, I'm trying to filter on the resource's Type :
Work, Material, Cost
But the system reject any test on these words. It seems it's waiting for
Have you any idea to test on this Type field?
Even though the Type field displays text data, the underlying data is
actually numeric. So, you have to test for the following numbers in your
Work resource = 0
Material resource = 1
Cost resource =2
Hope this helps.
Dale A. Howar...Converting resources in Exchange 5.5 to be compatable with Outlook 2003!
We running a NT4 Enviroment with Exchange 5.5 and and clients such as
Outlook 2000 and 2002 originally this was Inbox but over the years we have
uppgraded. OS's are 2K and XP. All working fine untill we starting
installing Office 2003 with Outlook 2003 and now we canot use resources like
calendar in Exchange 5.5 we can happy create new ones. Does anyone have best
way of upgrading resources to be compatable with Office 2003. In a about 4
mounths we going to Exchange 2003 but untill then I need a quick fix :-)
Thank you very much,
Are you referring to automatic bo...Resource Capacity Planning
I'm looking for an Excel application that illustrates resources availability
by week over time (3-6 months)
Click Software > On-Line Catalog > Excel Software > Management Software
Scroll down and look for "Scheduler" (free excel file)
"Paul Hipgrave" <firstname.lastname@example.org> wrote in message
> I'm looking for an Excel application that illustrates resources
> by week over time (3-6 months)
...How do Resource Groups relate to Resources
I am trying to figure out the linking table / GUID that connects Resource
Groups to Resources/Users. Does anyone know what table in CRM connects
There isn't one. The group membership is defined in an XML document that is
stored in the Constraints field of the ConstraintBasedGroupBase table (which
is linked to ResourceGroup by them both having the same primary key value)
David Jennaway - Microsoft Dynamics CRM MVP
> I am trying to figure out the linking table / GUID tha...How to group bars showing counts and overlay line compliance chart
Using data similar to what's below (month, ticket count type, customer, SLA
compliance %), I'd like to be able to have the bars with the # of tickets
opened and closed for each month grouped so the bars touch each other while
still having space inbetween each months' bars (using the 1st axis). I only
can seem to find an option that determines the space between all bars...not
allowing me to group the bars for a given month.
As a second issue, the SLA compliance % data for closed tickets won't show
up as a line chart overlaying the bar chart described above. I can get
m...Resource file (rc) units
I am currently trying to port a MFC app to the wxWindows API.
My problem is I would like to convert a rc file to the wxwindows resource
format but I don't understant units used in MS file.
IDD_LECTEUR_DIALOG DIALOGEX 0, 0, 679, 471
STYLE DS_ABSALIGN | DS_SETFONT | DS_MODALFRAME | WS_POPUP | WS_VISIBLE
FONT 8, "MS Sans Serif", 0, 0, 0x1
CONTROL "",IDC_PANEL_CENTRAL,"Static",SS_LEFTNOWORDWRAP |
LTEXT "",IDC_STATIC_PANEL,36,138,593,195,0,WS_EX_...Trying to export a group from Entourage 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
What is the key to exporting a "group" from my address book without exporting the whole address book?? I am trying to export in order to use them on a different account. Thank you...
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=iso-8859-1; format=flowed
On 2010-03-02 16:16:27 -0800, RJP@officeformac.com said:
> What is the key to exporting a "group" from my address b...Group mail
How to send a group mail to all the addresses in address
book and I want to display only their address in their
mails. I dont want to show entire list of all addresses.
Please let me know.
...Calendaring / Resources in 2K7?
Is there anything for resources built into E2K7? Are we still to use some
sort of auto accept?
On Thu, 14 Sep 2006 09:19:02 -0700, Dan
> Is there anything for resources built into E2K7? Are we still to use some
>sort of auto accept?
Much of that will be built-in:
Yep - works well, too. I blogged about the Calendar Concierge capability a
http://winzenz.blogspot.com/2006/06/exchange-2007-calendar-concierge.ht...Multiple Grouping Headers on Form like Reports
Is there anyway to specify addtional grouping headers and footers on
forms similar to the way you can on a report?
Thanks in advance
Not that I'm aware of.
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"WAstarita" <WilliamAstarita@gmail.com> wrote in message
> Is there anyway to specify addtional grouping headers and footers on
> forms similar to the way you can on a report?
> Thanks in advance
Would subforms do it for you?
We sell licensed software modules that come with annual licensing and
maintenance. Suggestions on how to set up unit groups?
"Each" for the Product?
"Year" for the License (with a 3-year being a selection)?
...How to release resources hold by Creating Rescue Recovery process
In Windows XP SPK3, on IBM Laptop T60.
I followed the instructions to create the rescue/recovery CDs. At one
point, there was a window screen telling me to wait while it was extracting
needed files. So, I waited. After more than 10 minutes (I thought), the
window screen went away, then NOTHING was shown to tell me what to do (I
supposed to get the window screen to tell me using the CD drive and insert
blank CD, ..., etc.). I waited another 20 minutes and still nothing was
shown. So I REBOOTED the system and retried the procedure. This time, after
I clicked "creating...How to get the resource from Resource Only Dll
if(hr == NULL)
MessageBox("This is not working");
MessageBox("This is working");
here, i am try to get the image(gif) resource,which is stored in the dll(for
example testdll.dll). Where as image resource type is "GIF"
And resource ID is 504. But i am unable to find the resource.
But when i try this
Where i have also stored an BITMAP file, and tried find the resource . i
have succeded in th...Using XSD stored in assembly resource with includes
I am trying to validate an XML file against an XSD that is stored in the
assembly as an embedded resource. I can get it to work as long as the XSD
does not include other XSDs. After a fair amount of searching, I have found
3 possible solutions but none have worked for me. They are:
1. Use the Includes property of XmlSchema to add included XSDs, then call
XmlSchema mainSchema = XmlSchema.Read( stream1, null );
XmlSchema includeSchema1 = XmlSchema.Read( stream2, null );
XmlSchema includeSchema2 = XmlSchema.Read( stream3, null );
mainSchema.Includes.Add( includeSchema1 ..."Resource" has declined
One of my conference rooms returns this error for a few users but not all
When scheduling a meeting according to the proper procedure, the resource is
rejecting the meeting with the following error:
"Resource" has declined your meeting because it is recurring. You must
book each meeting separately with this resource.
--The meeting is NOT recurring.
--Other conference rooms do not exhibit this behaviour
--No changes (that I am aware of) have been made to the exchange
server or the resource account.
...Top 50% Grouped by Month
I have two fields in a query which are Month and MedTime. I want to get the
top 50% of the values or top half by month. The query returns about 200
records with about 15-20 records per month. So if October 09 has 20 records,
I want to return the highest ten MedTime values. If November has 15 records,
I want to return the top 7-8 records. So I would want the top half values
for MedTime grouped by month. Can someone help?
You'll need a unique key column in the table to do this. If you don't
already have one add an autonumber column. Then use a subquery...