Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - 2 independent queries in one report
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

2 independent queries in one report
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
tmwong View Drop Down
Newbie
Newbie
Avatar

Joined: 26 May 2005
Location: Malaysia
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tmwong Quote  Post ReplyReply Direct Link To This Post Topic: 2 independent queries in one report
    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.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
tmwong View Drop Down
Newbie
Newbie
Avatar

Joined: 26 May 2005
Location: Malaysia
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tmwong Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 07 July 2005 at 8:44pm
for the report to make sense they need some kind of relationship
Blog | MPG Tracker
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.