[AccessD] Gantt chart in Access

Susan Harkins ssharkins at gmail.com
Mon Feb 8 18:32:14 CST 2010


I didn't even use a function -- I'm sure I used an expression in a query to 
return the bar.

Susan H.

> Create the following function.
>
> Function Plot(startpos As Long, endpos As Long) As String
>  If Nz(startpos) < 1 Then Exit Function
>  If Nz(endpos) < 1 Then Exit Function
>  If endpos < startpos Then Exit Function
>  Plot = IIf(startpos > 1, Space$(startpos - 1), "") & String$(endpos - 
> startpos + 1,
> ChrW(&H2588))
> End Function




More information about the AccessD mailing list