473,701 Members | 2,594 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Query of a Query DataSheet

I am using MS Office Access 2003 (11.5614). My basic question is can
I run a query of a query datasheet. I want to use more that one
criteria and can not get that query to work. I thought I might be
able to accomplish the results in two steps by using two queries. If
this is possible how can I do it?

Thank you,

Stan Hanna

Sep 29 '07 #1
4 3129
On Sat, 29 Sep 2007 09:39:17 -0700, Stan wrote:
I am using MS Office Access 2003 (11.5614). My basic question is can
I run a query of a query datasheet. I want to use more that one
criteria and can not get that query to work. I thought I might be
able to accomplish the results in two steps by using two queries. If
this is possible how can I do it?

Thank you,

Stan Hanna
You haven't given sufficient information for more than generic help,
but yes, you can use one query as the record source for another query.

You can also use a form in which to enter the parameters. Then
reference the relevant form controls in the query:

forms!FormName! ControlName

As long as the form is open, any query that refers to the form and
it's control will run with the correct criteria.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Sep 29 '07 #2
Stan wrote:
I am using MS Office Access 2003 (11.5614). My basic question is can
I run a query of a query datasheet. I want to use more that one
criteria and can not get that query to work. I thought I might be
able to accomplish the results in two steps by using two queries. If
this is possible how can I do it?

Thank you,

Stan Hanna
You can create a query and then use that query in another query.

If this is related to a form, you can use recordsets. Ex:
Dim r As recordset
DIm r1 As Recordset
set r = Forms!TheForm.F orm.Recordsetcl one
r.filter = "CustomerID = 1"
r.sort = "DateEntere d"
Set r1 = r.OpenRecordset
Sep 30 '07 #3
Stan <st*******@hotm ail.comwrote in news:1191083957 .648184.270350
@k79g2000hse.go oglegroups.com:
My basic question is can
I run a query of a query datasheet. I want to use more that one
criteria and can not get that query to work.
There's no problem in running a query of a query. (But I have no idea of
what you mean when you suggest running a query of a query datasheet).
Regardless, if you have six criteria, will you be happy with running a
query of a query of a query of a query of a query of a query?
And if you are, and the queries are saved queries, and something isn't
quite right, will it be easy for you to investigate just what that is?
And if you share your work, will Uncle Phil be able to figure just what
you are doing or have done there.

Why not ask about "I want to use more that one criteria", the problem
which you actually have?
Everybody should know how to write such a query, and by using your
suggested bypass, you will pass up the opportunity to learn that very
basic skill.
Posting a copy of your effort that doesn't "work" is likely to get a
helpful response quite quickly.
Unless it's ludicrous, of course. Then it will generate multiple
absurdities. Lately 75% of the questions and 85% of the answers here have
been ludicrous, so you'll just fit right in; no need to worry

--
lyle fairfield

Think free Aim Mail is a good deal? 4 gig storage! IMAP too! I have an
account. It has about two thousand messages stored on Aim's server. But I
can't access the account, nor the stored messages nor new messages. Do I
have the username and password right? I'm pretty sure because I can log
into the account with an instant message program like Miranda or
Trillian. And they can tell me I have fifteen new e-mails. But for two
weeks I can't login with the webmail interface, nor with IMAP, nor with
POP. So, be careful with Aim mail. Cuz there seems to be no recourse.
And, yes, I know the terms I agreed to specify AOL has no responsibility
whatever. But maybe this will help you remember those terms are for real
and your e-mail may disappear forever.



Sep 30 '07 #4
On Sep 29, 10:10 pm, lyle fairfield <lylef...@yahoo .cawrote:
Stan <stanha...@hotm ail.comwrote in news:1191083957 .648184.270350
@k79g2000hse.go oglegroups.com:
My basic question is can
I run a query of a query datasheet. I want to use more that one
criteria and can not get that query to work.

There's no problem in running a query of a query. (But I have no idea of
what you mean when you suggest running a query of a query datasheet).
Regardless, if you have six criteria, will you be happy with running a
query of a query of a query of a query of a query of a query?
And if you are, and the queries are saved queries, and something isn't
quite right, will it be easy for you to investigate just what that is?
And if you share your work, will Uncle Phil be able to figure just what
you are doing or have done there.

Why not ask about "I want to use more that one criteria", the problem
which you actually have?
Everybody should know how to write such a query, and by using your
suggested bypass, you will pass up the opportunity to learn that very
basic skill.
Posting a copy of your effort that doesn't "work" is likely to get a
helpful response quite quickly.
Unless it's ludicrous, of course. Then it will generate multiple
absurdities. Lately 75% of the questions and 85% of the answers here have
been ludicrous, so you'll just fit right in; no need to worry

--
lyle fairfield

Think free Aim Mail is a good deal? 4 gig storage! IMAP too! I have an
account. It has about two thousand messages stored on Aim's server. But I
can't access the account, nor the stored messages nor new messages. Do I
have the username and password right? I'm pretty sure because I can log
into the account with an instant message program like Miranda or
Trillian. And they can tell me I have fifteen new e-mails. But for two
weeks I can't login with the webmail interface, nor with IMAP, nor with
POP. So, be careful with Aim mail. Cuz there seems to be no recourse.
And, yes, I know the terms I agreed to specify AOL has no responsibility
whatever. But maybe this will help you remember those terms are for real
and your e-mail may disappear forever.
Lyle,
I agree with you, I should learn to do it correctly, with a multi-
criteria query, but if you look at my posting in this discussion group
under "Query Conflict" you will see I have been trying without much
success. Now that I have a Query of a Query working, proving an
immediate answer to my needs, I will go back to working the multi-
criteria query problem. In the interim I thank you and all of the
other responders. I have learned a great deal.

Stan Hanna

Sep 30 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4754
by: William Wisnieski | last post by:
Hello Everyone, Access 2000, I have a main unbound form with a bound datasheet subform . The subform is bound to a query that returns records based on criteria in the main form. The user then double clicks a row on the datasheet subform to open yet another form bound to a table . These two forms are linked by the field. So far so good.
1
1616
by: PeteCresswell | last post by:
I've got a query that comes up with a dataset list in < 3 seconds when run just in DataSheet mode...but the same query, when run as intended (Append to an empty table) takes upwards of 30 minutes to run. The target table is via an ODBC link to a temporary DB on the user's C: drive. The source tables are a mixture of Oracle, Sybase, and JET tables - all via ODBC links. Each component of the query comes up very quickly when run by...
3
3122
by: thomas goodwin | last post by:
I have a query which asks for a parameter value to execute it. To see the results I have to: a) click on the query -- the "Enter Parameter Value" window pops up. b) enter the parameter value c) look at results in datasheet view If I want to run the query again, I must d) click to close the datasheet view e) click on the query f) enter the parameter value
2
3154
by: Simon Pleasants | last post by:
Am something of a newbie at this, so please bear with any stupid questions. I have created a database to track shipments that we import. The information is stored in a table and I have created a form which displays the information from the table. The end users have access to the form only - this is deliberate. I have created some queries, including parameter queries, to aid them which are accessible via buttons on the main form. ...
2
2580
by: Dave Burt | last post by:
Hi, Access officionados, I'm new here, so please cut me slack/gently tell me off if I'm out of line or in the wrong place. OK, here's something that seems silly (and is also problematic to me). I have a query which is updateable when viewed as a datasheet in Access (you can insert, delete, update). Using queries, I can insert and update, but not delete.
0
1078
by: Dave Stone | last post by:
Can anyone explain what is happening here? 2 tables tblA and tblB, each with a code column and a full-text column (e.g. C001, "Joe Bloggs"). tblA contains a small subset of the rows in tblB. There is a query joining these as follows: SELECT tblA.Code, tblA.Adata, tblB.Bdata FROM tblA INNER JOIN tblB ON tblA.Code = tblB.code; tblB.Code is the primary key in that table.
7
9333
by: deko | last post by:
SELECT tblTxAcct.TxAcctName, tblTxType.TxTypeName, Nz(qryTxAcctListCt.TxCount, 0) AS TxCt FROM (tblTxAcct INNER JOIN tblTxType ON tblTxAcct.TxType_ID=tblTxType.TxType_ID) LEFT JOIN qryTxAcctListCt ON tblTxAcct.TxAcct_ID=qryTxAcctListCt.TxAcct_ID; I use this query as a RecordSource for a Datasheet that displays Accounts, Types, and the number of Transactions in each Account. An Account cannot exist outside of a Type, but an Account...
0
1730
by: ET | last post by:
We have two tables... one with primary key ID and second table with secondary key to the ID in the first table... Now, they query pulls records from both tables, looks like this: SELECT tblCell_Sat_Phone_Main.ID, tblCell_Sat_Phone_Main., tblCell_Sat_Phone_Main., tblCell_Sat_Phone_History.Location, tblCell_Sat_Phone_History.,
0
1374
by: ghat12 | last post by:
I have created a search form that displays results in separate datasheet which is launched by specifying the queryname in the OnClick property of a command button on the search form. My problem is that when the query-datasheet is launched, it blocks the search form making repeat searches inconvenient. Is there someway to control the XY coordinates of the launch position of the query-datasheet? FYI, the query-datasheet is not part of a...
0
8736
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9229
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8977
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8934
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7824
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6571
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5904
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3102
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2035
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.