Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by linusx

  1. linusx

    Null CDate issue

    Haha, after all this I just found out using the module outside of Access, I.E. using ASP; it can not be done with Access. So I am testing it with the other query. Thanks, Bill
  2. linusx

    Null CDate issue

    Duane, Thanks a lot the module worked out great. Thanks so much. Bill
  3. linusx

    Null CDate issue

    Duane, Yes that is what I have, but currently it is not possible to change this field. I would love to, but it is an existing application that runs a lot of other pieces. Thanks, Bill
  4. linusx

    Null CDate issue

    Duane, Thanks, not sure what you mean. Could you give me an example? SQL queries are not my strong point specially Access. Thanks, Bill
  5. linusx

    Null CDate issue

    Hello PHV, Thanks, but I just realized that some of the rows contain text strings and are not null. Those rows return #ERROR and still can't sort by those dates. Any ideas? Thanks, Bill
  6. linusx

    Null CDate issue

    Hello Everybody, I have this query: SELECT Affiliate_id, Date_Payment_Received FROM Class_Students WHERE IIF(ISNULL(CDate([Date_Payment_Received])), CDate('1/1/1980'), CDate([Date_Payment_Received])) > #1/1/2006# It always returns "Invalid Use Of Null" Date_Payment_Received is a text...
See more

Part and Inventory Search

Back
Top