Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Oct 2003
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Is Null (Access 2000)

    I'm trying to compare this years sales to last years sales.

    There are several items in the query that need to be compared. Example G1-04 vs G1-05, B1-04 vs B1-05 . . .

    I have the query set up as:

    G1-04 is not null and G1-05 is null
    or
    B1-04 is not null and B1-05 is null . . . .

    The query seems to run fine BUT I'm trying to create a maketable so I have a snapshot of who we've targeted and it won't let me do it. The message that pops up says, "You tried to assign the null value to a variable that is not a Variant data type." Should I be using something other than Is Null? If there's a purchase than there's a number in the field but if they did not purchase then it's blank. I used a crosstab query to sum the sales.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Is Null (Access 2000)

    You'll have to provide detailed information about the query/queries involved, or post a stripped down version of the database. (See <post#=401925>post 401925</post#> for instructions.)

Posting Permissions

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