Results 1 to 2 of 2
  1. #1
    Standtruec is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2016
    Location
    New Zealand
    Posts
    2

    Compile error in query expression.

    I have recently updated to access 10 64 bit system. Now I get this error when I run my query. This was running fine in the 32 bit access.
    Click image for larger version. 

Name:	Compile error.jpg 
Views:	10 
Size:	13.0 KB 
ID:	24517
    Here is the information in the sql view of my query.

    SELECT tblProducts.ProductID, tblProducts.ProductName, Sum(nz([Received])-nz([Sold])) AS [Units in Stock]
    FROM tblProducts INNER JOIN tblTransactions ON tblProducts.ProductID = tblTransactions.ProductID
    GROUP BY tblProducts.ProductID, tblProducts.ProductName;



    Can anyone help me get this to work? Thanks in advance.

  2. #2
    Standtruec is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Apr 2016
    Location
    New Zealand
    Posts
    2

    Red face Solved

    I fixed my problem. This is how I did it. I created a new blank database and imported all my tables, forms,queries and reports. Then I did compact and repair on my database and this fixed my problem. I did not import the module from my old database.

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

Similar Threads

  1. Compile error in Query Expression - Help
    By vad77 in forum Queries
    Replies: 6
    Last Post: 10-29-2015, 03:05 PM
  2. Replies: 11
    Last Post: 05-01-2014, 11:56 AM
  3. Replies: 5
    Last Post: 06-19-2013, 10:24 AM
  4. Replies: 3
    Last Post: 03-05-2013, 11:17 AM
  5. Replies: 6
    Last Post: 05-30-2012, 12:32 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