Results 1 to 3 of 3
  1. #1
    Nhung is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2018
    Posts
    3

    Need Urgent help: Sum value in crosstab query is not correct


    The issue has been resolved. The reason of this issue is my mistake.

    Thank you for all.
    Attached Thumbnails Attached Thumbnails Add field NgayHD.png   Not add field NgayHD.png  
    Last edited by Nhung; 05-19-2018 at 09:27 AM.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    ??What the????
    try Q1 as a sum,(does it sum correctly?)
    THEN Crosstab Q1.

  3. #3
    Nhung is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    May 2018
    Posts
    3
    hello Ranman,

    I try the Query as sum, but it sum not correct.

    Click image for larger version. 

Name:	Try query as sum.png 
Views:	8 
Size:	13.5 KB 
ID:	34107

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

Similar Threads

  1. Replies: 5
    Last Post: 09-12-2014, 06:41 AM
  2. Query help urgent
    By IKNOWNOSQL in forum Queries
    Replies: 1
    Last Post: 06-29-2011, 05:15 AM
  3. Replies: 9
    Last Post: 06-26-2011, 09:14 PM
  4. Urgent Query Help Please
    By AccessFreak in forum Queries
    Replies: 1
    Last Post: 06-23-2011, 06:02 AM
  5. Query to run from a FORM VERY URGENT
    By prag in forum Forms
    Replies: 14
    Last Post: 10-08-2009, 01:51 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