[mso] Re: Creating Access Querries From Other Querries
- From: "Tillotson, Robert N (US SSA)" <robert.tillotson@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 9 Nov 2007 11:19:01 -0500
Ray,
The easiest way to do this is to select the first query in the database
window and then hold down the control key while you drag the query to a
blank spot in the window. IT will copy with the name copy of... your
original query. Easy to edit the name then by selecting the copy and
press F2. Then edit the query.
Robert Tillotson
BAE-IT
Groton Field Office
860-441-2207
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Ray Shapp
Sent: Friday, November 09, 2007 11:03 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Creating Access Querries From Other Querries
To All,
It seems to me that it should be easy to create new queries in Access
2002 by modifying existing ones, but I was unable to do so. I want to
create twelve separate queries that differ very little. Most of the
selection criteria are identical. Just one field is different. The
resultant reports go to twelve different people.
Please give me some guidance on how to save a copy of a query with a new
name while keeping the original query intact. From that point, I can go
into Design View and make the necessary change to one criterion.
Thanks for the help.
Ray Shapp
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister
group. This group will not allow for posting of emails, but will allow
you to join and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
FILE SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your
email messages, read these instructions that explain why and how to fix
it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
