Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  compound command statement

Author  Topic  max2 Starting Member 5 Posts Posted - 2001-01-31 : 07:07:38 Hi Someone can explain me how uses a compound command statement ? I have this question about compound command statement : <%SQLQuery1 = "SELECT * FROM orari where matricola = " & mat & " and entrata = 1 and mese = " & corrmese & " order by data, hh, mm"%> <%Set rsCustomersList1 = objConnection1.Execute(SQLQuery1) %> <%SQLQueryUsc = "SELECT * FROM orari where matricola = " & mat & " and entrata = 0 and mese = " & corrmese & " order by data, hh, mm"%> <%Set rsCustomersListUsc = objConnection1.Execute(SQLQueryUsc)%> I would like use the NextRecordset method to view the data in a recordset that uses a compound command statement made up from SQLQuery1 and SQLQueryUsc. Thank's