Reset Integer Value to Null 1

[SgtJarrow]

Search feature is down right now.....

Using Access 2000...have about 150 integer variables ina declarations statment.

Looping through several thousand records at a time.

During processing, some of the variables are set to certain values. When the next loop starts, I need to reset all the variables to Null....can't use 0 as this is a valid number.

I wanted to stay with integers but will chnage my variables to variants if necessary.

Anyone know a way to reset an integer to a Null state??? Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[mp9]

I can't get an Integer or a Long to take a Null value, sorry. Looks like a Variant may be the way to go.

http://www22.brinkster.com/accessory/

 

[SgtJarrow]

yep....already changed the code.....thanks anyway. Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCSA, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com