Results 1 to 2 of 2
  1. #1
    jerem is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    88

    Crosstab Query And Cache List Data (sharepoint)

    Hi,

    My data is on Sharepoint. I have a simple Crosstab query that works well unless I choose the option Ms Access option "Cache List Data". In that case I get a Type Mismatch error. Any idea what it could be?

    Code:
    TRANSFORM Sum(PivotData.QuoteTotal) AS SumOfQuoteTotal
    SELECT PivotData.FullName
    FROM PivotData
    GROUP BY PivotData.FullName
    PIVOT PivotData.StatusText;


  2. #2
    jerem is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2012
    Posts
    88
    Turns out that the issue was a data type issue due to Null value. Still don't know why it was working when Sharepoint was not caching.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 AM
  2. Replies: 0
    Last Post: 01-17-2013, 07:43 AM
  3. Link Access Query to Sharepoint List
    By mlm in forum SharePoint
    Replies: 0
    Last Post: 04-24-2012, 03:06 PM
  4. Sharepoint List Query Filter based upon User Login
    By Steven.Allman in forum SharePoint
    Replies: 5
    Last Post: 03-22-2012, 11:30 AM
  5. Convert a crosstab set of data to a flat list
    By jamesrees02 in forum Queries
    Replies: 3
    Last Post: 02-17-2012, 06:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums