Report from 2 Tables

[brsawvel]

Hello,

I have a comments report that is bound to tblComments. I have 2 textboxes I need to add to the report that need to be bound their respective fields in tblMain. Both Tables have a fldTaskNumber. How do I associate those two textboxes to tblMain so that the record in tblComments and tblMain (linked by fldTaskNumber) appear at the same time on the report?

 

[Kryst51]

Build a query that joins the two tables, that has all of the fields you want your report to have. Then build your report based on the query.

If you don't want to start from scratch, you can open the report properties and open the query builder from there, which should show what you have so far.

 

[brsawvel]

dumb question...where's the query builder? using 2003

 

[Kryst51]

click queries to the left side of the access strip then there should be a choice to design a query, which you can either use a wizard or it will open in design view.

 

[brsawvel]

I created a new query and linked my report to it, but it isn't working. Here is a jist of what I have

In the report:
tblA.fldA
tblA.fldB
tblA.fldC
tblA.fldD
tblB.fldA
tblB.fldB

Common Thread between tblA and tblB:
tblA.fldE
tblB.fldC

The query I generated has the fields from both tables. After that, I don't know if I need to add criteria or what...

 

[Kryst51]

What happens when you run the query from the QBE, does it return the results you want?

Can you post you db without any sensitive info?