Filter a report in an auto email code

[DJRhino1175]

I'm leaving the NZ() in there as it works with no issue as for what I need it to do. But I need to start a new thread for a different issue I'm having with coda associated with this.

Thanks for all your inputs as I'm learning a lot. I'm creating .txt documents to keep a lot of the special codes created for any future projects that may need them so I do not have to reinvent the wheel.

[twinnyfo]

DJ,

Another tip--instead of saving as a text file, you can have a separate module (or even a separtae Database) that holds some frequently used Code. This way you can simply cut and paste into your new projects.

All of us here at Bytes are glad you are beginning to look at the bigger picture of DB design, and over time this will benefit you.

Looking forward to working with you on your future projects!

[DJRhino1175]

Thanks twinnyfo, never though of just making a DB to hold all of them. This will definitely be helpfully as I have accumulated several .txt docs.

[NeoPa]

If this were Facebook I'd add 'Like's to both posts #16 & #17.

Good stuff in both and congratulations to DJ on handling his learning & progression so well.

[zmbd]

Oh, yes... I have a database with modules named for the type of VBA (email, excel, outlook, encryption, etc....) contained. I used to have them in *.bas files however I have so many of them now that it was becoming a pain to search