Hello,
My program selects data from an Access database and is controlling on the ID field which is of datatype AUTONUMBER. I cannot get an equal comparison no matter what type of statement I've used unless I use a literal (which, of course is not a real option). For example:

Select * from Events where id = 328 works great.

Select * from Events where id = mynumericfield (which contains 328) does not work.

Select * from Events where val(id) = mynumericfield (which contains 328) does not work.

Is there something different about this datatype that I'm not aware of? Anybody have any clues?

Thanks in advance!

Barry

P.S. This is really a VBScript program with a VFP interface (6.0 SP3),but a Select statement is a Select statement (Isn't it?).