Results 1 to 2 of 2
  1. #1
    salonikije is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Location
    Montenegro
    Posts
    21

    Question Creating a chart to the report, where the values displayed in the fields on the same report

    Dear,
    Is there any way to create a chart without using table or query as a source, but using only data shown on the same report in custom fields?

    I have this situation on my report:



    Click image for larger version. 

Name:	tabela.png 
Views:	7 
Size:	9.4 KB 
ID:	28888

    Marked fields show counted data from table "Tasks", using DLookUp function, defined in a similar way as shown:

    Click image for larger version. 

Name:	ControlSource.png 
Views:	7 
Size:	22.5 KB 
ID:	28889

    Every filed in first screenshot has an unique name and I want data from marked to show on column-type graph.


    Thnx in advance!
    Aleksandar

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Short answer - no. The chart RowSource must reference a table or query or be an SQL statement. All of my charts use an SQL statement.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-22-2016, 06:31 AM
  2. Replies: 1
    Last Post: 07-25-2014, 11:43 AM
  3. Replies: 1
    Last Post: 10-10-2013, 12:58 PM
  4. Creating a report using the same fields
    By clawschieff in forum Reports
    Replies: 3
    Last Post: 04-17-2013, 12:48 PM
  5. Creating Dummy Fields in a Report
    By Whehir in forum Reports
    Replies: 2
    Last Post: 06-13-2012, 05:45 PM

Tags for this Thread

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