Hi i want to create a query on the fly. Meaning i have a query that contains, name,class,group,attend,date.... What i want to do is select a certain date from this query and put them into another query(temperary if possible). can this be done.
I'm using MS Access,VB6...

Thanking you in advance
Chris lynch