MS Access equiv. of in()?

mithril

Was wondering if anyone knows of an MS Access equivalent to MySQL's in() function. Ya I know, MS Access isn't a real database but this is for a PHP-GTK app I'm modifying which supports both MySQL and MS Access (and soon FrontBase and MS SQL) since MS Access is an easily deployable method when part of the target audience in on Win32 and may not have MySQL installed. Any thoughts are welcome.

-geoff

Anon

Says it's there:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/html/output/F1/D2/S5A329.asp

I know I've used it, or something similar, to select from a list of values. I remember it performing badly with longer lists (which weren't that long). Man, their site sucks - it added 20MB to IE, maxed the CPU, and tooks minutes to display :-P

mithril

Thanx!! Discovered that it was actually a data type mismatch that was causing the query to fail, but that link is a great help for any further MS Access SQL questions that may arise.

Thankfully I don't need to worry about the select performance issues as much. The IN() is being used in an update query designed to batch edit multiple values being scanned into the db from the filesystem. Thus, the total number of values in the list is usually going to be very small (< 100). The app is an MP3/DVD/CD catalogue, and the program obviously can't guess what Category or Sub-Category the user will choose to classify files into (though it does pick everything else out of the ID3 tag🙂.

-geof