Ooops. So what is my alternative? I need to look up certain values in tables and place them into variables. If I can't do this with a SELECT INTO then what do you suggest? Unlike Access, in PL/SQL when you use SELECT...INTO, you are actually placing the the returned values into variables, not tables. So, how can I get this functionality in Access?
Originally posted by r937 "select into" creates a table, not a variable
you musta got only one row of one column to make you think that :-)