View Single Post
 
Old 04-05-2016, 06:53 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

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.
Reply With Quote