Hey Paul!
Hi Paul, I have started to test with your latest code now that I think I have cleaned up my report.
Looks like things are finally moving forward as hoped, with all thanks to your dedication in helping solve the problem. I am still ashamed that one letter caused so much grief. My apologies for not being very thorough, but it all starts to look the same after a while.
I am using this sql statement:
Code:
StrSQL = "SELECT * FROM [CORE$] WHERE [TYPE]='" & itype & "' AND [SIG_CREW]='" & isubresp & "' " & _
"ORDER BY [STARTS] ASC, [COMPLEX] ASC, [UNIT] ASC"
The merges seem to be going well, except for:
1) I need directory type. Right now I getting letter type merges. Where do I need to change that?
2) I am having a heck of a time establishing the time fields in a h:mm AM/PM time format despite having included switches. The date switches worked fine, just not the time.
{ MERGEFIELD E1_Start \@"h:mm AM/PM" } - with ALT-F9
3) I am getting duplicate reports being run, but this may not be related to the module you helped me with.