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.
