Auto Export

[leighms]

Hi
I have set up a button that I click on enter two date ranges and then it exports multiple reports to excel. The issue I have is on report lists reasons down the side and date across the top, however the reason are exporting as numbers and not as text. If I export the report manually in access its fine, just not sure why this is happening

 

[jdraw]

Are you using a lookup field in one of the underlying tables?
We really need to see something to help with context.

 

[leighms]

attached sample

 

[jdraw]

I would not use lookup fields at the table level. See EvilLookups
In the query QryTime5:30to6:00, for example, I recommend you design using the
tblCallsReceived and the tblReasonsForCalling as per the image attached. Store the ID of the reason in the tblCallsReceived and use the tblReasonsForCalling to lookup the text associated with the ID.


I don't know enough about your application, but you need to get the underlying structures designed to meet your needs.

My best guess is that your issues stem from the lookup fields in the table.

Good luck.