Add A Querie to the Report

[BowBeforeMeMySlave]

Greetings! I am creating a report. However there is a problem. I need to print a result from my querie to the report. This is the said querie
"Select Transaction,Amount
From Sheet1
Where VoucherNo = VN
"
VN is an input where the grouping will be done.


However, I do not know how to proceed.
It seems there is no button as to how to add a field to Report(a blank one my friend) where I can designate its value as the result of my querie. How will I proceed?

By the way other questions:
If I have this table
VoucherNo Transaction Amount Name

How would I do it so at each page I have all of the reports unique to the VoucherNo and the Transactions and Amounts are grouped by VoucherNo. Thanks. ^^

[jzwp11]

You would use the following query:

Select VoucherNo, Transaction,Amount
From Sheet1


Create a report based on the above query. Set up a group on VoucherNo, include both the header and footer for the group and include the sum of the amount field in the footer.

Now to show the report for only 1 voucherNo that you choose, create an unbound form with a combo box. Base the combo box's rowsource on the following query:

SELECT DISTINCT VoucherNo
FROM Sheet1

Include a button on the form. In the code behind the button, you can filter the report as follows (you will have to substitute your particular names below):

DoCmd.OpenReport "YourReportName", acViewPreview, , "[VoucherNo]=" & Me.comboboxname

[BowBeforeMeMySlave]

Cool dude! Now I have another question, how can I place a new field on the report which is not existing on the database?

I have two amounts and I want to add them and the resulting thing would be the new field. Help?

[jzwp11]

I'm not sure I understand. You can add the values in two controls on the report by using an expression in a third control, but the 2 controls that supply the values that need to be added would have to be in the same record. According to your earlier post you only have the amount field.

If the 2 amounts are for the same voucher, you would use the sum() function in a control that you would place within the group footer for the voucherNo.