Results 1 to 2 of 2
  1. #1
    manos39 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Feb 2011
    Posts
    16

    syntax in query expression #ERROR help!

    i have a query (Qrminas) to calculate a running sum of workhours of empoyees per month and i get #error in the field ΣΥΝΟΛΑ

    SELECT Qrevdomada.[ΑΝΑ ΕΤΟΣ], Qrevdomada.[ΑΝΑ ΜΗΝΑ], Qrevdomada.ΥΠΑΛΛΗΛΟΣID, Qrevdomada.ΕΠΩΝΥΜΟ, Sum(Qrevdomada.[ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ]) AS [ΣΥΝΟΛΟ ΜΗΝΟΣ], DSum("[ΣΥΝΟΛΟ ΜΗΝΟΣ]","Qrevdomada","[ΑΝΑ ΜΗΝΑ] <= " & [ΑΝΑ ΜΗΝΑ] & " And [ΑΝΑ ΕΤΟΣ] <= " & [ΑΝΑ ΕΤΟΣ] & " And [ΥΠΑΛΛΗΛΟΣID] = '" & [ΥΠΑΛΛΗΛΟΣID] & "'") AS ΣΥΝΟΛΑ


    FROM Qrevdomada
    GROUP BY Qrevdomada.[ΑΝΑ ΕΤΟΣ], Qrevdomada.[ΑΝΑ ΜΗΝΑ], Qrevdomada.ΥΠΑΛΛΗΛΟΣID, Qrevdomada.ΕΠΩΝΥΜΟ;

    [ΑΝΑ ΕΤΟΣ]= year date field
    [ΑΝΑ ΜΗΝΑ] = month date field
    [ΥΠΑΛΛΗΛΟΣID] =employeeid
    [ΕΠΩΝΥΜΟ] = surname
    [ΔΙΑΦΟΡΑ ΣΕ ΩΡΕΣ] = totals per week


    can you help? i believe it is the syntax
    i upload my db

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Your data types are off, and I don't see the field being summed in that query. This produces results, with a field picked at random:

    ΣΥΝΟΛΑ: DSum("[ΘΕΩΡΗΤΙΚΕΣ ΕΒΔΟΜΑΔΑΣ]","Qrevdomada","[ΑΝΑ ΜΗΝΑ] <= '" & [ΑΝΑ ΜΗΝΑ] & "' And [ΑΝΑ ΕΤΟΣ] <= '" & [ΑΝΑ ΕΤΟΣ] & "' And [ΥΠΑΛΛΗΛΟΣID] = " & [ΥΠΑΛΛΗΛΟΣID])
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 13
    Last Post: 12-05-2011, 05:10 AM
  2. Syntax Error in Query Expression on filter
    By alaric01 in forum Forms
    Replies: 1
    Last Post: 10-14-2010, 07:23 AM
  3. Syntax error (comma) in query expression?
    By TheWolfster in forum Queries
    Replies: 5
    Last Post: 05-10-2010, 12:02 PM
  4. Syntax error (comma) in query expression
    By KLynch0803 in forum Programming
    Replies: 3
    Last Post: 01-18-2010, 03:35 AM
  5. Replies: 1
    Last Post: 10-07-2009, 07:36 AM

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