I am trying to group data for a specific event and have not been successful,
so I am hoping someone can help.
ID Date Value
174 12/3/2007 102
174 12/3/2007 909
174 12/11/2007 405
174 12/11/2007 701
206 12/6/2007 1001
173 12/3/2007 500
I want to group by ID, the MAX Date for that ID and the Max Value for the ID
& Max Date
The desired result would be:
ID Date Value
174 12/11/2007 701
206 12/6/...query based distribution group
running Exchange 2007 sp2, I need to modify an existing query based DL so it
finds mailboxes and if the account has two different email address stamped
on it. For example if the mailbox has test1.com and test2.com and it's a
mailbox then make it a member of the query based DL
Thanks for any help
If it has those two e-mail addresses? That should return just one
Or do you mean a recipient with any two proxy addresses? I don't believe
that's possible with LDAP.
Or do you mean a mailbox-enabled user with proxy addresses in two domai...Group Footer at Bottom of Last Page of Group
I would like for a group footer to appear at the bottom of the last page
of a group -- either hide the page footer on pages if it is not the last
page of the group or have the group footer print at the bottom of the page.
I have used the instructions to reset the page number and the total page
count for each group. (http://support.microsoft.com/kb/841779/en-us) I
was hoping to be able to set it where if the page equals the total pages
of the group, it will make the page footer visible. For some reason, if
there is more than one page, it doesn't work properly.
I have also used the i...Creating Universal Groups with Distribution Group members?
We have a Windows 2003 Active Directory with Exchange
2003, and I don't really want to duplicate work, but I
think I may have to (ugh!).
Here is the deal. I need to create an All Managers
Universal Group with every group that has managers in
it. So, what I tried doing, was I created a Universal
Group and added the _All Managers DL into it -- but that
didn't seem to work, according to my boss who asked me to
create this UG for him. So, my question is, am I not
allowed to add DL members to a Universal Security Group?
And if now, is there any way that I can take...Distribution Group list
I have a problem with the distribution group list. Here
it goes: I removed and deleted the account from this
group list but whenever I send a task, it always tries to
reach this deleted account and give me a undeliverable
error message. Please help. Thanks
Restart Exchange services.
> I have a problem with the distribution group list. Here
> it goes: I removed and deleted the account from this
> group list but whenever I send a task, it always tries to
> reach this deleted account and give me a undeliverable
> error message. Please help. Thanks
...Data, Group got error message Cannot shift object off sheet
I created a command grouping several columns together by going to Data, Group.
When I go to click on the "-" sign to group. It gives me an error
message;"Cannot shift object off sheet". Why? and how can I fix it.
Maybe you have some objects that get rearranged when you hide the columns using
your grouping symbols.
This may have some suggestions that work for you. It's kind of a similar
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
Remember to look for comments and merged ...Local Data Groups
Does anyone know if its possible to create local data groups for offline
clients and somehow push the groups out to all users, rather than going to
each outlook laptop client?
You can deploy the SFO client using group policies. When the user next logs
onto the domain the SFO client will be installed
Microsoft CRM MVP
"Jo Savidge" <JoSavidge@discussions.microsoft.com> wrote in message
Hi, I'm building a work schedule to calculate needed employees versus
4 week history in sales. I have the spreadsheet laid out with th
employees listed in the first column and the time of day accross rows.
I have two seperate schedule sections, one for cooks, and one fo
delivery drivers(pizza delivery). I have the spreadsheet functional
it can calculate how many people I need at various times of the day, d
the math for projected sales and give me a total hours worked AND giv
me estimated labor percent for that week.
What I WANT to do is have all of the employees time calculated an
tra...graphing by group
I have 10 individuals in 5 groups.
I would like to graph the individuals but keeping them
within their groups. When I try to graph it ends up as 10
I would also like to make each group of individuals a
In Step 2 of Chart Wizard make sure you have Series by Rows or Series by
Columns correctly selected.
If you groups are in different columns us Series by Columns other wise use
Series by Rows
remove CAPS in e-mail address
"Tim Pasma" <email@example.com> wrote in m...managing distribution groups
I am running exchange 2003 and I would like to know is there a way and I can
have a regular user maintain my distribtion groups. If so how would I go
Thanks so much
You can grant permissions at the disty group level to allow ordinary members
to add and remove users. Be careful to only do disty groups as security
groups changed by users in outlook is a touch insecure.
"Mike B" <MikeB@discussions.microsoft.com> wrote in message
> Hello all,
> I am running exchange 2003 and...Passing option group value to vba function
I'm sure I've done this before but can't for the life of me figure it
out now, and hours of research online haven't helped. I'm simply
trying to pass an option group value from a form to a vba function.
I'd like the user to choose option1 or option2 and when they click a
button, the function will run an if statement like "if
I've got 2 options named option1 and option2 and a frame called
frame20, what else do I need? I've also tried bounding the selection
to a textbox, but keep getting errors. Any help on the process?
Tha...DSum by group
I have a textbox with a DSum function, but would like it to query only within
each group. It seems that most other functions (e.g Avg) automatically
calculate by group, but DSum doesn't seem to be.
The text box is within the Group Footer, and I'd like it to return a
different value below each group.
"RussG" <RussG@discussions.microsoft.com> wrote in message
>I have a textbox with a DSum function, but would like it to query only
>within...Re: Protecting worksheet with grouped cells
I have a worksheet which has rows as well as cloumns
grouped. After protecting the worksheet I am unable to
expand and collaspe my groups.
error:"You cannot use this command on a protected sheet..."
Is there a work-around/solution to this problem?
You can only enable outlines and have worksheet protection through a macro:
.EnableOutlining = True
The EnableOutlining property (and UserInterfaceOnly) is not saved with the
workbook unfortunately, so this code would have to be run ...Grouping and grouping within groups
I really need help, and help fast, so thank you ahead of time! I nee
to know how to group and group within a group. I have been able to d
a group, but once I group within the group and try to group anothe
group withing that group it combines them. I know I can put a spac
between the information so it doesn't combine them but that doesn'
seem to be the right way to do things. For instance I have thre
different area codes and I want to group them, then within those group
I have five different colors of houses in that area code. I want t
group the different colors within their area ...Show Groups as Page Header
I used the report wizard to create a report based on a table. The table has
252 records. When I preview the report, it only shows 242 records. The
records are sorted / grouped by district. In the table, the fields are
The wizard placed the District and field names into the District Name
Header. To make the report more readable, how can I get the group headers to
be the page headers? That is, if a group prints over more than one page, how
can I get the page header to show the group name?
You can set the "Repeat Section" property of the Gro...E2K3 Storage Groups
What are advantages, and more importantly, disadvantages to using multiple
Storage Groups. I have heard that having more then 2 SG's creates extra CPU
load, is this true? The only benefit I see so far is logical separation for
use in exchange manager, and that you can point translogs and system path to
different locations, if you had different physical drives, I could see this
as a benefit.
I have a situation where I'd like to do the following
-Storage Group for local users
- Multiple stores with different store policies
-Storage Group for remote users
- Multiple stores with diff...Project Server 2007 Groups not Synchronizing with AD
In my production instance, I have 2 security groups that synchronize with AD. This week, they no longer synchronize.
There are no errors. AND, the training instance has exact same setup - the sync works fine in that instance. Any idea what could be causing this issue?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Online Courses Available for Eggheadcafe.com Users
My apologies. Only one of the 2 security groups will not sync. I removed the AD...configuring news group in exchange5.5
can anyone tell me as how to configure news group in
thanx in advance.
...Tax Schedule on Drop Ship Purchase Orders
Can anyone tell me why the tax schedule is not loaded when we enter a drop
Using the same vendor and item on a standard PO results in the correct tax
schedule being loaded into the transaction.
Thanks in advance for your help.
...Distribution Lists as Security Grouping
Very quick question. Why is it that I am unable to use my Exchange DL in
assigning permissions to a Public Folder?
Exchange 2003 Enterprise SP1
Windows 2003 Standard SP1
.... because Distribution Groups are not security principals, cannot be
.... use Security Groups. If you mail-enable them they get the same
functionality as distribution lists as well.
"Kirrin Jones" <firstname.lastname@example.org> wrote in message
ne...Exchange Distribution Group Usable externally.
I've created a distribution list with domain and external user in it.
It works fine if a domain user uses the group...the message gets sent
to everyone. If an external user send to the distribution group, only
the domain users get the message. Is there a way to set up the group
so that when an external user sends to the distro group, everyone in
the group gets the message?
ugh...this works, turns out I just have a brain lapse...
...How to add URLS in emails and send in groups
I send group emails to my customers and have my email list grouped
alphabetically. Each email group I send to, I copy and paste from the
previous email into the new one, but the URLS never transfer and I have to
constantly renew the URLS.
Of course, MS doesn't have anything like this in the help section!!! URRGGGH
Any help would be appreciated!
You can create a category in the Contacts instead of copy from an old email.
"mustardseed5" <email@example.com> wrote in message
news:898EB790-5640-487F-8F06-4DD14F...Sports Schedule Grid
Could someone point me in right direction which would allow me to take the
sports schedule referenced below:
select game schedule, then "in Excel format"
and extrapolate out each individual team's separate schedule, similar to
Sept. 16 Field 3 101 vs 103
Sept. 23 Field 1 104 vs 101
Oct. 3 Field 5 101 vs 107
Oct. 9 Field 22 102 vs 101
Sept. 16 Field 6 102 vs 118
Sept. 23 Field 15 109 vs 102
Oct. 3 Field 2 105 vs 102
Oct. 9 Field 20 102 vs 101
The schedule template is in th...grouping rows...
if I want to group the rows by dept, do I have to select dept1 and group
them, and select dept2 and group... for every dept?
any better ideas?
Data | Filter | Autofilter
is probably the fastest way to simply look at rows with specific DEPT#
entries in them. If you've got some special need to do much more than that
with them, then we'd need a more detailed explanation of what you want to do
with this information.
> DEPT1 ...Task Scheduler
For the first time I have a need to work with scheduled tasks; I find lots
of links to Eduardo Morcillo's code in the archives but all of them are
dead. Does anybody know where I can find the info for dealing with
scheduling from VB6?
This may be what you want:
It's "Edanmo's Task Scheduler DLL"
The page linked is the index of his downloads
folder. I've found that his website has been pretty
much non-functional for a long time, and he's been
de-emphasizing VB, but the downl...