Exporting a Report To Excel

J

jdthomas_gmac

Several of my tables utilize a lookup wizard, and when I export a
report to excel, access sends my autonumber primary key as opposed to
the second column of my table which houses the appropriate data (Date,
rank, etc). How do I export the correct data?
 
O

OfficeDev18 via AccessMonster.com

Several of my tables utilize a lookup wizard, and when I export a
report to excel, access sends my autonumber primary key as opposed to
the second column of my table which houses the appropriate data (Date,
rank, etc). How do I export the correct data?
Click to expand...
I've been stung before by Access's lousy exporting of reports to Excel. I've
learned my lesson. Now what I do is export the report's record source or a
query based on that record source.
 
D

Duane Hookom

Include the "correct data" in your report's record source query so you can
bind the text boxes to the proper fields.
 
Top