[AccessD] Report filter property

Arthur Fuller fuller.artful at gmail.com
Thu Aug 12 13:06:10 CDT 2021


Good idea.

On Thu., Aug. 12, 2021, 1:32 p.m. Bill Benson, <bensonforums at gmail.com>
wrote:

> Ok so my point was that function isn’t one I would keep in my library as
> is, I would add at least a branch for dates.
>
> On Thu, Aug 12, 2021 at 10:50 AM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
> > I always used # on dates in any SQL statement.Habit.  Why try without,
> > possibly generate an error and then have to correct it? Delimiting a date
> > with the #, AFAIK, will not cause a problem.
> >
> > r
> >
> > On Thu, Aug 12, 2021 at 5:37 AM Bill Benson <bensonforums at gmail.com>
> > wrote:
> >
> > > Did that sample leave out bookending dates as
> > >      & “#” & Ctl.itemdata(varitem) & “#”
> > >
> > > Or have I been adding them unnecessarily for my entire career??  :-(
> > >
> > > On Wed, Aug 11, 2021 at 9:49 AM Martin <martinreid at gmail.com> wrote:
> > >
> > > > http://www.baldyweb.com/multiselect.htm
> > > >
> > > > Martin
> > > >
> > > > On Wed, 11 Aug 2021, 14:31 Arthur Fuller, <fuller.artful at gmail.com>
> > > wrote:
> > > >
> > > > > I want to pass an In() clause to a report. Can I use the filter
> > > property
> > > > to
> > > > > do this?  The port was originally  written to accept  one
> parameter.
> > I
> > > > want
> > > > > to remove  and use the In() instead
> > > > > What  is the syntax? I have a multi-select  listbox that builds on
> a
> > > > dialog
> > > > > that builds the In() clause for me.
> > > > > --
> > > > > AccessD mailing list
> > > > > AccessD at databaseadvisors.com
> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > > Website: http://www.databaseadvisors.com
> > > > >
> > > > --
> > > > AccessD mailing list
> > > > AccessD at databaseadvisors.com
> > > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > > Website: http://www.databaseadvisors.com
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list