In a command button, how do I run a select query and then query the results. Ideally I don't want to create a table, can the 1st result be stored in memory and then queried?
e.g. Select id, date from table where id = '12345'
Select id, date from (above results) where date = '01/01/01'