A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple Queries...?



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 05:36 PM posted to microsoft.public.access.reports
SummitSeeker
external usenet poster
 
Posts: 3
Default Multiple Queries...?

Hello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.

Our clients make multiple payments for the same order. They may make a
deposit with a Check then pay the balance with a Credit Card.

I am trying to make a section on the invoice that shows the date of each
payment and the last 3 digits of the card used or the check number.

I have a querie that finds all records in the "Payments" table with the same
"OrderID". How can i make a section on the Invoice that will display ony the
payments for the current invoice?

I assume that I need to link the OrderID on the current report but i cannot
figure out how to display the information, especially when there is more than
one payment.

Thanks for the help...
-H-
  #2  
Old June 2nd, 2010, 09:51 PM posted to microsoft.public.access.reports
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Multiple Queries...?

I am trying to make a section on the invoice that shows the date of each
payment
I never heard of payments listed on invoice but we all learn something new.

Your invoive should currently have a subreport that list all the line items.
that is how you list the payments also.

In the query for the invoice report add the query for the payment in this
manner within the SQL view --
SELECT tblInvoice.*, qryPayments.*
FROM tblInvoice LEFT JOIN qryPayments ON tblInvoice.OrderID =
qryPayments.OrderID
....

--
Build a little, test a little.


"SummitSeeker" wrote:

Hello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.

Our clients make multiple payments for the same order. They may make a
deposit with a Check then pay the balance with a Credit Card.

I am trying to make a section on the invoice that shows the date of each
payment and the last 3 digits of the card used or the check number.

I have a querie that finds all records in the "Payments" table with the same
"OrderID". How can i make a section on the Invoice that will display ony the
payments for the current invoice?

I assume that I need to link the OrderID on the current report but i cannot
figure out how to display the information, especially when there is more than
one payment.

Thanks for the help...
-H-

  #3  
Old June 3rd, 2010, 03:50 AM posted to microsoft.public.access.reports
SummitSeeker
external usenet poster
 
Posts: 3
Default Multiple Queries...?

Thanks for the reply Karll.. that got it...

Regarding the invoice with payments... We take deposits to reserve material
for our clients and nail down a better lead time becasue the material has a
long lead time and it keepsus from having to keep a large inventory on hand
and the client knows when to expect delivery... We post the deposit as a
payment, and then send the invoice back to the client with the remaining
balance... a little strange but it works.. Thanks again...

-H-

"KARL DEWEY" wrote:

I am trying to make a section on the invoice that shows the date of each

payment
I never heard of payments listed on invoice but we all learn something new.

Your invoive should currently have a subreport that list all the line items.
that is how you list the payments also.

In the query for the invoice report add the query for the payment in this
manner within the SQL view --
SELECT tblInvoice.*, qryPayments.*
FROM tblInvoice LEFT JOIN qryPayments ON tblInvoice.OrderID =
qryPayments.OrderID
....

--
Build a little, test a little.


"SummitSeeker" wrote:

Hello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.

Our clients make multiple payments for the same order. They may make a
deposit with a Check then pay the balance with a Credit Card.

I am trying to make a section on the invoice that shows the date of each
payment and the last 3 digits of the card used or the check number.

I have a querie that finds all records in the "Payments" table with the same
"OrderID". How can i make a section on the Invoice that will display ony the
payments for the current invoice?

I assume that I need to link the OrderID on the current report but i cannot
figure out how to display the information, especially when there is more than
one payment.

Thanks for the help...
-H-

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.