Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Location
    Earth | North America | United States | California | Long Beach
    Posts
    62

    Unanswered: Null Values in Make Table Query

    I have a Make Table query that stops before it can build the table and tells me that I am trying to write a Null value to a nonVariant.

    All of these fields are coming from other tables. I am not calculating any fields.

    Is there any way to find where my problem is AC2000 does not give me any details on where the offending records are.

    Any help is appreciated.

    Jack

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Null Values in Make Table Query

    In VBA, you may not assign a NULL value to a NonVariant data type variable. However, you are talking about just a query, so this seems not to be the case.

    Could you post your SQL text?
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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