Hi Guys,

I have a report that is already created in Microsoft Access. What I need to do is create some VBA code that will using some calculations, produce an SQL statement and then get me a set of data. I then want to use that set of data in the report.

I need to be able to use VBA because the information needs to be calculated to make the query.

Once I have my data set using SQL (i can do this) how do I go about using it in the report.

Shane