P
peashoe
I have the following Query that gives me the data I need to get the
following in my report
SELECT Attendees.[Extended Days],
Packages.[Extra Room Price],
Packages.[Plus Price],
Packages.Price,
Packages.Display,
Registrations.[School Or Organization],
Registrations.ID,
Registrations.[S/O Address Line 1],
Registrations.[S/O City],
Registrations.[S/O State],
Registrations.[S/O Zip],
Registrations.[S/O Country],
Registrations.[Contact First Name],
Registrations.[Contact Last Name],
Registrations.[Contact Address 1],
Registrations.[Contact Address 2],
Registrations.[Contact City],
Registrations.[Contact State],
Registrations.[Contact Zip],
Registrations.[Contact Country]
FROM Packages INNER JOIN (Registrations INNER JOIN Attendees ON
Registrations.ID = Attendees.[School Or Organization ID]) ON
Packages.[Package Code] = Attendees.[Package Code]
WHERE (((Registrations.[School Or
Organization])=[Forms]![Registrations]![School Or Organization]))
ORDER BY Packages.Display;
My invoice looks like this now:
Report Header: Contact Information (Registration Table)
Page Header: Title of my report (Display, Price, Total, etc)
Detail: Packages.Display, Packages.Price, Packages.Plus Price,
Packages.Extended Days, Total
Page Footer: Grand Total
Report Footer
Everything is working great. But now I need to add data from my
Transaction table to display:
Transaction.Description, Transaction.Amount
after all the Package rows are complete. How do I do this?
Thanks in advance
Lisa
following in my report
SELECT Attendees.[Extended Days],
Packages.[Extra Room Price],
Packages.[Plus Price],
Packages.Price,
Packages.Display,
Registrations.[School Or Organization],
Registrations.ID,
Registrations.[S/O Address Line 1],
Registrations.[S/O City],
Registrations.[S/O State],
Registrations.[S/O Zip],
Registrations.[S/O Country],
Registrations.[Contact First Name],
Registrations.[Contact Last Name],
Registrations.[Contact Address 1],
Registrations.[Contact Address 2],
Registrations.[Contact City],
Registrations.[Contact State],
Registrations.[Contact Zip],
Registrations.[Contact Country]
FROM Packages INNER JOIN (Registrations INNER JOIN Attendees ON
Registrations.ID = Attendees.[School Or Organization ID]) ON
Packages.[Package Code] = Attendees.[Package Code]
WHERE (((Registrations.[School Or
Organization])=[Forms]![Registrations]![School Or Organization]))
ORDER BY Packages.Display;
My invoice looks like this now:
Report Header: Contact Information (Registration Table)
Page Header: Title of my report (Display, Price, Total, etc)
Detail: Packages.Display, Packages.Price, Packages.Plus Price,
Packages.Extended Days, Total
Page Footer: Grand Total
Report Footer
Everything is working great. But now I need to add data from my
Transaction table to display:
Transaction.Description, Transaction.Amount
after all the Package rows are complete. How do I do this?
Thanks in advance
Lisa