Results 1 to 2 of 2
  1. #1
    nile80 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2020
    Location
    Bosnia&Herzegovina
    Posts
    2

    name and sum in querie


    problem is. when I reduce IDKonto to 4 digit I want to name change to name in Konto table. for example. in table IDKonto I have 21130001 named aaaaa, 21130002 named bbbbb, 21130003 named cccc and 2113 named "abc". when I reduce digit to 2113 I want in Querie Razdv sum (21130001,21130002,2113003 =300 and name "abc").
    Attached Files Attached Files
    Last edited by nile80; 02-07-2020 at 05:00 AM.

  2. #2
    Join Date
    Apr 2017
    Posts
    1,792
    Code:
    SELECT Int(prom.Konto/10000) AS Konto4, k.NazivKonta, Sum(prom.Duguje)
    FROM Promjene AS prom LEFT JOIN Konto AS k ON k.IDKonto =  Int(prom.Konto/10000)
    WHERE k.IDKonto BETWEEN 1000 AND 9999
    GROUP BY Int(prom.Konto/10000), k.NazivKonta;

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

Similar Threads

  1. Querie Error
    By googalabosh in forum Queries
    Replies: 1
    Last Post: 09-01-2017, 12:15 PM
  2. querie grouping
    By rmceuen in forum Access
    Replies: 1
    Last Post: 09-19-2014, 11:54 AM
  3. Querie Help
    By Jramosent in forum Queries
    Replies: 1
    Last Post: 09-18-2013, 02:22 PM
  4. Need a querie that updates.
    By imlost2 in forum Queries
    Replies: 1
    Last Post: 08-20-2011, 09:06 AM
  5. querie problem
    By TIMT in forum Queries
    Replies: 2
    Last Post: 05-31-2009, 10:12 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