Been trawling sites for a few weeks trying to find answers about my SQL and have finally come up with this SQL (VB6 and MS Access):

Code:
sSQL = "INSERT INTO try([mytext], [mydate]) SELECT quantity From Stores Where CatalogueNo = '" & txtSearch.Text & " ' "
This uses two tables and drags the field 'quantity' where txtSearch = a certain value in the stores table and inserts it into the try(mytext) table. I have a field, mydate which I want to have a todays date but according to this SQL it needs to have a field from stores.

Can I INSERT todays date INTO the try(mydate) table without having to SELECT it FROM the the Stores table?