PC Review


Reply
Thread Tools Rate Thread

Display more than one query

 
 
=?Utf-8?B?TW9sZTk0?=
Guest
Posts: n/a
 
      6th Oct 2006
Hello,
I have an access table and I have four queries I run off it. Each query
pulls some different information off, but each query requires two dates to be
input. What I would like to do, is to display the results of each query, all
of them on a single page. The query results are not large (only a few lines),
so they will fit on one page. What would be even better would to be just have
one query which would pull off the information in one go, but as the query
results are not related, I don't think that this is possible.
Thanks
 
Reply With Quote
 
 
 
 
JK
Guest
Posts: n/a
 
      6th Oct 2006
You can do it in one query,

You will need a common field in both tables. Create a query, bring both
tables into it, link them on the common fields and select all the fields
that you want in the query from both tables.

Regards/JK

"Mole94" <(E-Mail Removed)> wrote in message
news:7C7E640A-72ED-4197-9B04-(E-Mail Removed)...
> Hello,
> I have an access table and I have four queries I run off it. Each query
> pulls some different information off, but each query requires two dates to
> be
> input. What I would like to do, is to display the results of each query,
> all
> of them on a single page. The query results are not large (only a few
> lines),
> so they will fit on one page. What would be even better would to be just
> have
> one query which would pull off the information in one go, but as the query
> results are not related, I don't think that this is possible.
> Thanks



 
Reply With Quote
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      6th Oct 2006
You can display the queries using a subform or subreport. If there is no
common key fields which link them, you simply need to make sure that none of
them use a link to either each other or the main form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Mole94" <(E-Mail Removed)> wrote in message
news:7C7E640A-72ED-4197-9B04-(E-Mail Removed)...
> Hello,
> I have an access table and I have four queries I run off it. Each query
> pulls some different information off, but each query requires two dates to
> be
> input. What I would like to do, is to display the results of each query,
> all
> of them on a single page. The query results are not large (only a few
> lines),
> so they will fit on one page. What would be even better would to be just
> have
> one query which would pull off the information in one go, but as the query
> results are not related, I don't think that this is possible.
> Thanks



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display query data based on another query Adnan Microsoft Access Queries 1 10th Sep 2008 04:57 PM
Display Query Cyndi Microsoft Access Queries 2 29th Aug 2008 11:11 PM
Trying to display query paramiters on the query based report fcmedina78 Microsoft Access Reports 3 8th Jun 2008 06:33 AM
Query display??? rblivewire Microsoft Access Queries 1 1st Mar 2006 02:27 PM
Need macro to run query, open form and display query results in form fields denilynn Microsoft Access Macros 2 3rd Mar 2004 07:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.