Automated Report Export

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Automated Report Export

Post by Leesha »

Hi Hans!
I couldn't wait to get home to try this. It's perfect!! Now I'm just praying the user doesn't decide to attach a different attachment based on the number of days out. They haven't said that is the plan but I wouldn't put it past them.
Thanks so much,
Leesha

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Automated Report Export

Post by HansV »

That shouldn't be too difficult - you might create a table with two fields: the number of days (240, 220, ...) and the path/filename of the attachments for each of those number of days.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Automated Report Export

Post by Leesha »

Great idea! I'll keep that in mind if they make the request and look back to code you game me this summer where we put the path in a table.
Thanks!
Leesha