Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    San Bernardino, California, USA
    Thanked 0 Times in 0 Posts

    Update Query (97)

    I have been working on a database (see thread 536,547) and was using test data I created. Then, I discovered that the million plus records in the real data table actually had the date field stored as a text value.

    I am trying to use an update query to update the date. the old date field (actually a text field) is DatePosted and I created a new field AdjDate that designated a date field. I have a screen capture of my update query below. When I try to run it, I get an error - Data type Mismatch in Criteria Expression.

    What am i doing wrong? BTW, I tried to simply change the field to date and it crashed due to insufficient memory/disk space.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Update Query (97)

    The Update to line should be
    That is, square brackets [ ] around the field name instead of quotes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts