REPORT

[Gambler]

Im connecting two queries [paceline1 and pacelin2 together in a relationship. Then Im making a report using these two queries. I would like to have the VI rating from both queries in my report. When i do this i get an error message in my report saying It is confused because I have two HX4 VI fields. How can I differentiate PL1 VI number from PL2 Vi number, so my report will accept them. If it isnt clear on what Im trying to go let me know.
Thanks
ed

[Rick]

Pick one of your queries and use expressions like

VI2: [nVI]

You are just renaming it in the query so Access can tell the difference.

[Gambler]

Thanks Rick Ill try that.

[Gambler]

It worked!!!!!!!!!!! I spent a long time trying to figure that one out.
Thanks ed