Access 查询问题

Question

Access 分页查询问题

根据网上学习资料用了以下做法 但是每次查询结果的ID是从2开始
结果是ID2-ID30
怎么从ID1 - ID30

                                int MaxPerPage = 30;
                                int Page = 1;
                                    Select.Format(L"SELECT TOP %d * FROM Information WHERE (ID > (SELECT MAX(ID) FROM (SELECT TOP %d ID FROM Information ORDER BY ID) AS T)) ORDER BY ID", MaxPerPage, Page);
                                    m_pRecordset->CursorType = adOpenStatic;
                                    m_pRecordset->CursorLocation = adUseClient;
                                    m_pRecordset->Open((LPCWSTR)Select, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);

Answer 1

ID > (SELECT MAX(ID)
->
ID >= (SELECT MAX(ID)