Recent content by Captain

here was my attempt with a recordset just to get the interest rows to work. i get an error message on the select sql saying there are too few parameters configured? i thought maybe if i split it up so open a recordset for the Interest first then do one for the trades hence rstInt and rstTRD...

thanks Davidatwork, i like the idea of not deleting the temp table. with the recordset idea though, is there not a way of achieving this via SQL? which means i can utilise the knowledge i have? otherwise i need to start learning all about recordsets. i started googling, and in it's simplest...

Hi, This is my first venture to Access, and although my sql is average my vb is non existent, so pls bear with me.... I wanted to create a trading journal where i can record my trades by uploading them via the broker statement (csv) and then attach my screen prints. I have attached a copy of...