Results 1 to 4 of 4
  1. #1
    zubair136 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2019
    Posts
    2

    ACCESS AUTO generate charts


    Dear All.

    i want to ask that i have a sample data logging .. which is automatically logging . i want a graphical represenation of logging. on the other forum. .how can i do that.
    any help will be appreciated.

    for Reference my data is like
    Click image for larger version. 

Name:	Capture.JPG 
Views:	16 
Size:	154.3 KB 
ID:	39211

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You need to build a chart object on form or report. What type of graph? Exactly which data do you want to graph?
    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.

  3. #3
    zubair136 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jul 2019
    Posts
    2
    i want to draw a chart which defines all the values at the given time interval ..

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    You need to be explicit on what you want.
    What are 'all the values'? Speed and Size are the same for all records so does it make sense to graph those?
    BatchTime would be the X axis values and then Temp would be Y axis?
    Provide a mockup image.

    A RowSource could be:
    SELECT [Batch Time], [T1_Temp(C)] FROM table WHERE [Batch No]=[enter batch number];

    If you want multiple batches then try:
    TRANSFORM First([T1_Temp(C)]) AS [T] SELECT [Batch Num] FROM [Batches] GROUP BY [Batch Num] PIVOT [Batch Time];


    Advise not to use spaces nor punctuation/special characters in naming convention. Better would be T1_Temp_C.
    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. Auto email generate
    By nherbert31 in forum Queries
    Replies: 4
    Last Post: 08-01-2017, 12:38 PM
  2. Use a Query to generate auto ID
    By banpreet in forum Queries
    Replies: 2
    Last Post: 07-28-2016, 01:28 PM
  3. Replies: 2
    Last Post: 05-17-2015, 04:05 PM
  4. Auto generate records
    By RokitRod in forum Database Design
    Replies: 1
    Last Post: 10-02-2012, 10:45 AM
  5. Auto Generate Record
    By mjhopler in forum Forms
    Replies: 2
    Last Post: 02-10-2010, 03:40 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