Results 1 to 3 of 3

Thread: Access Query

  1. #1
    Join Date
    Aug 2009
    Posts
    14

    Unanswered: Access Query

    New guy to MSAccess here and having a pickle of a time with a query that I assume would be pretty simple. Not sure what I'm doing wrong.

    I'm pulling data from a SharePoint (3.0) list that has a caluclated field. What I want to do is run a query that pulls in all items with a value of 0 (zero). When I go to the 'builder' button, I enter [Cycle Time]=0 as the condition.

    I get an error that states the expression is too complex to be evaluated... etc.

    Any ideas as I'm really stumped. Thanks!

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Please post the whole SQL statement of the query.
    Have a nice day!

  3. #3
    Join Date
    Aug 2009
    Posts
    14
    D'oh... sorry.

    SELECT [Policy Accounting Workflow Tracking: All Items].Status, [Policy Accounting Workflow Tracking: All Items].[Request Type], [Policy Accounting Workflow Tracking: All Items].[No# Of Completed Transactions], [Policy Accounting Workflow Tracking: All Items].[Cycle Time]
    FROM [Policy Accounting Workflow Tracking: All Items]
    WHERE ((([Policy Accounting Workflow Tracking: All Items].Status)="closed") AND ([Cycle Time]=0));

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •