Changing Object Dependency

[AMessyGuy]

Is it possible to change an object dependency? I can view them but I cannot
find a way to change them.

I have two reports: one for males and one for females. Each is based on a
"male" and "female" query. I needed to add a number of items to the reports.
I did this for the female report but I'd really like to avoid the tedious
task of doing it by hand for the male report. I want to copy the working
female report and just change its object dependency to the male query. Can
this dependency be changed or am I stuck just making the needed changes by
hand?

Thanks for any help you can offer.

 

['69 Camaro]

Hi.

I want to copy the working
female report and just change its object dependency to the male query.

Open the copy in Report Design View and open the Properties dialog window.
Select the "Data" tab and change the query name to the male query. Save it
and open it in Print Preview mode.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[AMessyGuy]

Thanks!!! I didn't see that as the solution because when I clicked on the
Data tab for the Male report it never displayed anything (not just blank
entries, no entries at all, just a gray nothing). So, I copied the Female
report and tried your suggestion--and it worked!

Thanks again.

--
Sometimes I wonder if men and women really suit each other. Perhaps they
should live next door and just visit now and then.

Hi.

I want to copy the working
female report and just change its object dependency to the male query.

Open the copy in Report Design View and open the Properties dialog window.
Select the "Data" tab and change the query name to the male query. Save it
and open it in Print Preview mode.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Thanks!!! I didn't see that as the solution because when I clicked on the
Data tab for the Male report it never displayed anything (not just blank
entries, no entries at all, just a gray nothing). So, I copied the Female
report and tried your suggestion--and it worked!

Thanks again.