Expressions in Report Link back to query?

[lovelykid23]

I have two tables and two query created based on the two tables. Then I created 2 reports, each report based on a query. The columns in two tables all have the same name. They are just different types of data.

So the 1st report is built based on Query1 and the 2nd report is on Query2. I created the 1st report before the 2nd one. In the 1st report, in the expression of a textbox, I just point at a column in Query1 as [ColumnA]. The 2nd report, the source is Query2. In the expression of a textbox, can I say just say [ColumnA] and Access will know that it is the [ColumnA] from Query2 or I have to say [Query2]![ColumnA] every time?

 

[pbaldy]

If the field names are the same, the report should work with either. The greater question is why 2 tables with same fields? Normally you'd have one table, with an extra field to denote the type.

 

[lovelykid23]

Thanks a lot.
Because they are still on the update so I have to keep 2 tables seperately.

 

[pbaldy]

Don't know what that means, but it's your baby.