[AccessD] Gantt chart in Access

Apart from the error checking, my function is just a single expression which you could use in 
a query:

=IIf([startpos] > 1, Space$([startpos] - 1), "") & String$([endpos] - [startpos] + 1, 
ChrW(&H2588))

-- 
Stuart

On 8 Feb 2010 at 19:32, Susan Harkins wrote:

> 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 = 
> > End Function
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com