Recent content by Stigmundfreud

I use subreports but.... I run two queries, one to record a rule that is mapped and one to record rules that are not mapped. I'd like to combine the output so the rules are all in one report and those that have no mapping appear highlighted...

Bob just to say thanks for your pointers, got it all working nicely and even moved all the excel macros into the access code so do all the formatting there now.

Thanks Bob I'll start playing with this tomorrow when I am back in the office.

Sorry for such a first post! I've been searching for a while now on a method to export to Excel using a preformatted template. I'm quite basic with my VB skills but quick to pick up once pointed in the right direction. I've successfully outputted to Excel without problem but I'd like to use an...