Re: Field not empty

From: B. Comrie (rbchip_at_hotmail.com)
Date: 11/22/04

  • Next message: B. Comrie: "Re: Selecting Records to Send to Report" 
    Date: Mon, 22 Nov 2004 01:24:06 -0700

    If it Is Not Null then it should have data in it, so an empty field will not
    show up. If you want it to show up you need a "date of leaving" in it.

    Is the datatype set to DateTime?

    B Comrie
    http://www.codewidgets.com

    "Robin Chapple" <robinski@melbpc.org.au> wrote in message
    news:p023q09hijjr7m7j4lot62elv73llhho41@4ax.com...
    > I have a membership database where the date of leaving is recorded.
    >
    > If I take a query and as for all records where that field Is Not Null
    > I lose one record.
    >
    > Visual inspection sees and empty field. I have used delete and back
    > space in the field but it is still missing from the query result.
    >
    > Is there something that I have missed?
    >
    > One possibility that occurs is to enter " must be a date field" in the
    > criteria but don't know how to do that.
    >
    > Thanks,
    >
    > Robin Chapple
    >
    >

  • Next message: B. Comrie: "Re: Selecting Records to Send to Report"