Print Page | Close Window

2 independent queries in one report

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=15732
Printed Date: 29 March 2026 at 5:17am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: 2 independent queries in one report
Posted By: tmwong
Subject: 2 independent queries in one report
Date Posted: 05 July 2005 at 11:26am
can i design a report based on 2 independent queries which has no relationship at all? i'm trying to do this by MS Access 2003.


-------------
I learnt from the hardships.



Replies:
Posted By: dpyers
Date Posted: 05 July 2005 at 1:57pm
Are you taliking about two reports on the same page, or data from 2 queries on the same line?

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: tmwong
Date Posted: 07 July 2005 at 11:19am
yes. two data in the sam line. e.g: the payment query and the invoice query in the same line. e.g: i want to design a statement report to get the  balance whenever my customer pay any payment to me.

-------------
I learnt from the hardships.


Posted By: michael
Date Posted: 07 July 2005 at 8:44pm
for the report to make sense they need some kind of relationship

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net