On Mon, 2009-06-01 at 21:51 +0200, Franz Wein wrote:
> Hi Keith
>
> This is a problem in nearly all database - systems - my solution - use a
> date of death for all your fishes for example the 31.12.2999 - normaly
> this date ist possilbe in all database. If a fish died - fill in the day
> of
On Sun, 2009-05-31 at 10:08 -0400, Drew Jensen wrote:
> >>
> >
> > Thanks Drew, but that comes up as an invalid SQL expression
> >
> > I've also tried <#11/1/1958# but that just returns an empty set.
> >
>
>
> Sorry forgot a small bit there...my mistake...
>
> IS EMPTY
>
>
>
> -
Thanks Drew, but that comes up as an invalid SQL expression
I've also tried <#11/1/1958# but that just returns an empty set.
Sorry forgot a small bit there...my mistake...
IS EMPTY
-
To unsubscribe, e-mail: users-uns
On Sun, 2009-05-31 at 06:41 -0400, Drew Jensen wrote:
> Keith Bates wrote:
> > I have a database table where I keep details of the fish in my tank.
> >
> > One of the fields is the date when the fish died.
> >
> > I want to make a list of currently living fish by searching for records
> > where