Creating a query out of another query
I have a query looking like that:
field1 field2 field3 field4 field5 field6
Data 1 Test 6
Data 5 Poly 10
I need a query from this query like this:
Field 1 Field 2
I'll really appreciate if someone can help me with this one
This should do it --
SELECT Field1 AS Field_1, Field2 AS Field_2
WHERE Field1 ...How to create a rule which triggers when a condition is NOT met?
.... for instance, in OLExpress and Pegasus one can create a rule with
the symbol "@" in the conditions and request the rule to "move to the
Junk email folder" all mail which do NOT meet the condition. I can't
seem to find this facility anywhere in MS Outlook.
Thanks for your help in advance and apologies if this question has
already been asked and answered elsewhere (if it *has* I would be
grateful for the link).
You can achieve this by creating a rule which works on all mail (by not
having any selection criteria) then use "except" th...Error message creating install package
I am trying create an install package but allways I get error message after
pressing OK at the final phase. The message is:
"The destination install subfolder name cannot contain any of the following
My subfolder's name is Family. Why this message?
Have a Nice Day!
...Creating a Calendar
Hey all. I am fairly proficient in Access, but I need some thoughts or
ideas from other people on ways that I could create a calendar out of
an Access database. If you have ever used MS Project, I'm looking to
create something similar to the calendar reports that you can create
It will be used to print out a calendar schedule for a training
center. I already have the tables and queries structured, I just can't
figure out a way to get it to take the start and end dates for a class
and display that in a calendar format.
If you have any ideas, have done this before or know of any...Personal Folder #5
I removed all services and removed all profiles from Control Panel\Mail.
When I opened Outlook I still had a personal folder showing all information,
but not new. When I tried to rename the .pst folder the personal folder was
still there but with "unable to display" message. How do I get rid of this
personal folder? Thanks in advance.
...Printing a booklet #5
I would like to print a four page booklet, each page is 8.5x5.5, which should
allow printing of the booklet on one sheet of paper. Pages 2&3 print
together, but pages 1 and 4 do not. Is there some way to make this print as
a two sided document without having to print the sides separately?
If you have a duplex printer the setting for printing both sides when you
select Print. Then go to the printer preferences.
"Miles" <Miles@discussions.microsoft.com> wrote in message
>I would li...Micosoft Mail 3.5
Can a Microsoft Mail account be setup in Outlook 2002?
"Barry Keegan" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Can a Microsoft Mail account be setup in Outlook 2002?
normaly not, but Diane Poremsky has a good website about this problem:
Share your Outlook pst file with several users: Public OutLook
review on ZDNet UK: http://reviews.zdnet.co.uk/review/41/2/4529.html
...You do not have security privileges to create SmartLists
We just migrated GP 9 from SQL 2000 to SQL 2005 a few months ago and
eveything is ok so far except for the SmartList Builder which gives us this
error when trying to generate a list using SQL tables "You do not have
security privileges to create SmartLists with SQL tables". Everything is
ticked in advanced security for SmartList Builder
Did you go to Tools >> SmartList Builder >> Security? You have to set up the
users or classes within SLB to use SQL views.
Charles Allen, MVP
"Mario Labonte" wrote:
> Hi all,
> We ...Insert another domain in exchange 5.5
I have a domain (domain-A) set in my exchange server 5.5,
everything It is OK, now I have to set another domain
(domain-B) in the same exchange server, so the user bill
will have to smtp accounts.
bill@domain-B.com.cc (default replay)
The configuratios of DNS and Firewall are OK, how can I
have two domains in the same exchange server 5.5 ?
Cleiton Silva wrote:
> I have a domain (domain-A) set in my exchange server 5.5,
> everything It is OK, n...Template to creat a "Quick Reference" guide
I was wondering if any one had a template for what we
refer to as a "Quick" reference guide. My vision for this
guide is a half-page formate to make it easer to carry
around and require less desk top space. If anyone has
something like that in either word/publisher/abode and do
not mind shareing it I would greatly appreciate it. You
can email me directly at tthompson@co/san-joaquin.ca.us.
...Rounding Numbers #5
How do I set and change my own rounding rules so that numbers will - for
example - round up from .3 rather than the standard rule? Any ideas will be
Look in Help for the CEILING() function. You may find the FLOOR() function
> How do I set and change my own rounding rules so that numbers will - for
> example - round up from .3 rather than the standard rule? Any ideas will be
...Create a Chart w/data from multiple worksheets
I have an excel file that has the following worksheets.
They each have data in the cell G15. I need the data from each of those
cells plotted on the same chart. We've been using Lotus and it was super
simple. I'm at a loss how to do the same thing in Excel.
Thanks to anyone who can answer this question!!
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Tia" <Tia@discussions.microsoft.com> wrote in m...Turning off feature that automatically creates dates?
When I type, for example, "4-44" (without the quotation marks) into a cell,
Excel automatically transforms the data into a date ("Apr-44").
How do I stop this?
Preformat the cells as Text (format|cells|Number tab)
then do the data entry
or prefix your entry with an apostrophe: '4-44
Jason Freeman wrote:
> When I type, for example, "4-44" (without the quotation marks) into a cell,
> Excel automatically transforms the data into a date ("Apr-44").
> How do I stop this?
-- ...Importing into Outlook 2003 from Excel (ss created in Office 2000)
Am having difficulty Importing data into Outlook/ Contacts
2003 from an older spreadsheet created in Office 2000.
Everything in steps to import works except the actual
transfer of data: e.g., the first field in the Excel
spreadsheet ("City" field) imports correctly into Contacts
(without any of the other imported fields). Then blank
records are added for as many records there are in the
next field: "Company" name.
Have cleared all Flags during the Import/Export function
in Outlook and am totally stumped as to how to fix.
Thanks so much for the help.
...Funny Exchange 5.5 OWA problem
I have a strange problem when using OWA. When accessed via the internet, I
hit reply on an email and the new window doesn't open up, whereas on the lan
it opens up fine.
Has anyone seen this before?
check any popup blocker software or toolbar. You need to allow pop ups for
owa to work. This is very common problem.
"Alex Cheng" wrote:
> I have a strange problem when using OWA. When accessed via the internet, I
> hit reply on an email and the new window doesn't open up, whereas on the lan
> it opens up fine.
We are using Exchange 5.5 and Outlook Web Access. We recently applied a
number of Microsoft critical updates to that server and now many of our
staff can't get access to their email from home. In some cases they are
using Macs and the browser Safari, or Netscape, or various versions of the
Microsoft operating system and IE. Does anyone know how to fix this?
Software Support Specialist
Jefferson County Public Library
"Jane Frasier" <email@example.com> wrote in message
> We are using Exchange 5.5 and...how do i create a crm contact from an inbound email?
i had crm v3 outlook client installed on friday and am spending the weekend
getting to know the upgrade before we have e-partners roll out the upgrade to
our sales guys onmonday. Does any one know how i create a crm record from an
inbound email from a new potential customer?
Try the following:
1. promote the email into a crm email activity via "Track in CRM" button
2. right click on the email address and select "add to contact" (standard
outlook feature), and then promote that contact into a crm contact via "Tack
in CRM" button
ht...Money Plus Deluxe #5
I upgraded to Money Plus Deluxe about 2 weeks ago and the conversion went
fine, however I can not update data from the bank. I have talked to support
at the bank and they tell me that I am doing everything right. They can see
me log in to download the latest info, but the software says "bank wants you
to change your password". I have changed the password with them on the
telephone with me and it is fine on their end. They told me to contact
Microsoft, but I cannot locate anyone to call. Any assistance would be
In microsoft.public.money, Sharon Z wrote:
I have created a Public Folder with a Task View as my MIS
Help Desk for my internal users. Occassionally the Task
Item will disappear. I DO NOT know why it disappears, can
you help me with this? Also, the users only fill in the
Subject line and sometimes additional information in the
body of the Task. That's all.
Your help would be greatly appreciated.
...Unread messages in Public Folders
I have two problems with public folders:
- OWA nor Outlook doesn't display count of unread messages, regardless
whether per-user read/unread information is checked or not
- I'm unable to setup Outlook to show desktop alert on new messages in any
public folder; the dummy rule with display desktop alert option doesn't
work - is it even possible?
Thanks in advance,
On Fri, 24 Feb 2006 16:21:05 +0100, "Robert Goldwein"
>I have two problems with public folders:
>- OWA nor Outlook doesn...public folder permissions #25
I have the same problem that was already posted by firstname.lastname@example.org on
01/09/2006, but he didn't get any answers:
We have email enabled public folders. This public folders have many
subfolders. Incoming emails were processed by the clients and finally moved
into one of the subfolders.
So the clients need to have rights to delete the incoming emails for moving
them but they shoudn't have the right to delete one of the subfolders.
We are using Exchange Server 2003.
What can we do?
Flatten your hierarchy.
MVP - Exchange
"Protecting the world from ...Erros when installing Business Portal 2.5
Hello all, I am getting some error's when installing BP 2.5. Additionally
when it finishes the installation, I cannot access the site I get a 404. I
experienced the 404 error on BP 2.0 when I had database problems.
Here are the errors in the installation logs for BP 2.5:
/* TimeStamp: 5/26/2005 2:25:46 PM Database: "n/a" Actor:
ERROR: Path (D:\Program Files\Microsoft Business Solutions\Business
Portal\Utilities\SQL\Upgrade\2.0.859.0\System\GP_COMMON\) did not exist.
~~The above statement executed successfully.
/* TimeS...Read / Unread Problem in mail enabled Public Folder
I've got a problem with our the "Maintain per-user read and unread
information for this folder" -function on our mail enabled public folders.
First, i disabled the checkbox "Maintain per-user read and unread.." in the
properties of a public folder. this worked without a problem for over one
Then, i disabled the checkbox on a seconde public folder. the next day, all
new incoming messages on both public folders remained in the unread-status,
even when they were opened!
i enabled the "Maintain per-user read and unread.."-checkbox on a public
fo...When Creating a new User, automatically add to Every Distribution List EXCH2000
Running Microsoft Exchange 2000. When we create a new user in Active
Directory, how do we set it up so that user is automatically added to
an "everyone" distribution list? Thanks.
email@example.com (dvd9) wrote in message news:<firstname.lastname@example.org>...
> Running Microsoft Exchange 2000. When we create a new user in Active
> Directory, how do we set it up so that user is automatically added to
> an "everyone" distribution list? Thanks.
Bump and posting to exchange.setup
...Can I use Excel to create a tutorial with an audio commentary?
I want to record the keystrokes (preferably with pauses) with an audio
commentary so that I can create mini tutorials for distribution to my