Slow Query Needs Some Peppering

[grovelli]

The ExportDataToExcelSQL query in the attached mdb runs fine but when I run it in the original db which has many more records, it takes 2 minutes to come up with the results. Any way to streamline the process?

[HansV]

qCom1Energia, qCom2Energia, qPne1Energia and qPne2Energia are based on two tables, but they only use dbo_c_LetturaGiornalieraSTD. You should remove dbo_c_PrecipitazionEPortata from these queries.

If you do that, ExportDataToExcelSQL doesn't need to be a Totals query.

[grovelli]

Thank you so much Hans