Calling Query in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables, payments and businesses. One of the columns (VendorNumber) in payments is a code number. That code number colum is also in the businesses, along with the name of the business.

I am creating a report that is using the payments table, but I need to have the business name appear in the text box.

So...I create a relationship between the tables of VendorNumber to Vendor Number. I create a Query with first field as VendorNumber and the first table as payments, the second field as VendorNumber and the second table as businesses.

In the report, I put =[ReportQuery]![VendorNumber]...
and I get a dialog asking me to 'Enter Parameter Value' 'ReportQuery', which I thought I had solved.

When I run the query along, it appears to do the right thing.

Any suggestions as to how to get this to work? I would appreciate getting responses at spork at alias.punkass.com. replace at to get my email address.

Thanks,
Spugnoir
 
Try
=[VendorNumber]


--

Ken Snell
<MS ACCESS MVP>


Spugnoir said:
I have 2 tables, payments and businesses. One of the columns
Click to expand...
(VendorNumber) in payments is a code number. That code number colum is also
in the businesses, along with the name of the business.
I am creating a report that is using the payments table, but I need to
Click to expand...
have the business name appear in the text box.
So...I create a relationship between the tables of VendorNumber to Vendor
Click to expand...
Number. I create a Query with first field as VendorNumber and the first
table as payments, the second field as VendorNumber and the second table as
businesses.
In the report, I put =[ReportQuery]![VendorNumber]...
and I get a dialog asking me to 'Enter Parameter Value' 'ReportQuery', which I thought I had solved.

When I run the query along, it appears to do the right thing.

Any suggestions as to how to get this to work? I would appreciate getting
Click to expand...
responses at spork at alias.punkass.com. replace at to get my email
address.
 
In the report, I put =[ReportQuery]![VendorNumber]...
and I get a dialog asking me to 'Enter Parameter Value' 'ReportQuery', which I thought I had solved.
Click to expand...

You're making it harder than it needs to be.

Base the report on ReportQuery. Every field in ReportQuery is
available as the control source of a textbox, just as if it were a
table. You don't need to "run" the query or use the query name - just
select the fieldname from the list.
 
Hai,

I am a new joiner of this comunity, and I really don't know how to operate
outlook express, is there some body can help me out???
 
Back
Top