Search results

SELECT DISTINCTROW CO2.STKEY, CO2.Year, CO2.SCHOOL_YEAR, CO2.TAG, CO2.HR, CO2.SURNAME, CO2.[First Name], CO2.COUFS1A, CO2.COUFS1B, CO2.COUFS1C, CO2.COUFS1D, CO2.COUFS2A, CO2.COUFS2B, CO2.COUFS2C, CO2.COUFS2D, CO2.COUFS3A, CO2.COUFS3B, CO2.COUFS4A, CO2.COUFS4B, CO2.COU1S1A, CO2.COU1S1B...

anelgp Thanks for your help. Some of it works. You have got me a lot closer. The code stops at: Set rsQuery = dbs.OpenRecordset("SELECT HR FROM QExportCount GROUP BY HR;", dbOpenSnapshot) The "QExportCount2" you suggested doesn't pick up the value on the form faithfully. It substitutes H10...

Thank you for your quick reply, arnelgp The query stands alone. To export the data from that query, yes, I could add a criterion, but that would mean making 60 queries, each with a different H*. The solution would be to add the criteria using a WHERE statement in the code and so cycle through...

Galaxiom, Thank you for your swift reply. Not much joy when I read that recordsets are exported ‘in all’ but I suppose that’s why it is named a record set. Your next suggestion makes some sense and I will try applying it. It is a new lead for me. As many of use do, we inherit a set of...

What I have done so far: Researched many sites including this one. Tried a number of suggestions, copied code, modified it. Not successful. What I don't need: No DoCmd Transfers please as my Excel SS has 4 rows for headings, some cells merged. I have been down that path for weeks and my...

"Hi Programmers I am new to this site and haven't used other sites much. I am a retired teacher and still work in the education field, now mostly with data. I am a novice, not a beginner programmer in Access. I have successfully bumbled my way to producing three significant Access DBs over the...