Cross tab query in Access of SQL server table: Is this the way ?

• Digs

  SSCertifiable

  Points: 7333

  More actions

  April 15, 2005 at 1:48 pm

  #164087

  Hi,

  I have an MS Access Front End(FE) on SQL server via DSN -less connection ODBC.

  I wish to do a cross tab query in MS Access based on SQL table.

  Is this the best way ?

  Create a pass thru query summarising the data to the highest level possible, via a SQL stored procedure or View maybe, then do a MS Access query off the pass thru query data return via Stored procedure.

  They other way is to do cross tab query in SQL server, and that seams very difficult ?

  Please advise ?

• Digs

  SSCertifiable

  Points: 7333

  More actions

  April 17, 2005 at 1:37 pm

  #553063

  I answer my own question.

  My access FE is MDB.

  Yes a pass thru query can easily be turn into a cross tab query at the MDB client end.

  Just need to run the SP before I build the query at the FE.

  Using a view may be slower as it builds off a full table. Testing pass thru query on either view or SP will give the best result.