I am wanting to create dynamic reports by passing a SQL string from VB6 to an access query and then calling a MS Access report from VB6 that is linked to the query I have just passed through. Is this possible and if so can someone please provide me with a code example for it.Thanks