Results 1 to 15 of 15
  1. #1
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102

    Use a saved value (not on a table) in a graph.

    It seems simple enough, yet I can't really seem to quite get it.
    I have a time difference in a report
    Click image for larger version. 

Name:	y33t.png 
Views:	7 
Size:	135.3 KB 
ID:	33391

    First column is start, 2nd is the end, 3rd is the time difference.
    The 3rd is NOT in the table, it's calculated right there. =24*(CDoble([Fin de la interrupción de servicio])-CDoble([Inicio de la interrupción de servicio]))

    I wanna make 2 graphs. 1 displaying everything ABOVE a day and a half (>36 hours) and everything BELOW a day and a half. The names that those hours belong to are in the table, but I wanna know if I HAVE to save the time difference in a table to be able to use it in the graph. Or do I have to make a 2nd report, which then pulls from the first?



    CONTEXT: Access It's installed so it uses the system's language, which is actually english, and yet it's spanish for some reason? Whatever, I know both so I don't much care, but I can't seem to change it. I'm sorry if it's confusing.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I recognise that calculation....
    You can use the calculation formula as a field in the chart SQL
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    I was afraid I'd have to use SQL...
    But wait, I have that in the format of that text box, do I HAVE to put that in SQL to use it in the graph?

    EDIT: NOT IN THE FORMAT. In the origin... sorry, I'm tired

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You can use the query designer if you prefer but that needs to be one of the fields.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    So I DO have to save it somewhere else then?

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    No. Use the table with your start and end values and enter the calculation formula in your query or sql statement
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Click image for larger version. 

Name:	Dif.png 
Views:	8 
Size:	192.0 KB 
ID:	33392
    And then boom, I can just use it then yes?
    I should probably put the names I want to use there as well.

  8. #8
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    I feel like it's always the same people answering every thread I post.
    I think it's Ridder over here, and the one with a cat on a hammock as a profile pic.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by TrulyVisceral View Post
    I feel like it's always the same people answering every thread I post.
    I think it's Ridder over here, and the one with a cat on a hammock as a profile pic.
    Some of us do spend a lot of time on here and also on other forums...orange has the ca on a hammock.
    June7 answers even more than both of us...

    If you can get your data displayed as you want in a query, you then use that for your chart and it should be ok.
    Shall I stop answering for a while?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Ok... something I failed to notice until now.
    Click image for larger version. 

Name:	1.png 
Views:	8 
Size:	51.9 KB 
ID:	33393
    I imported all this data from an excel spreadsheet. So of course the data is gonna be the same, so then I saw this in a different sheet of the same excel file:
    Click image for larger version. 

Name:	2.png 
Views:	8 
Size:	27.2 KB 
ID:	33394All those brackets and the date and time and all that, filtered out. Just the name of the agency (the thing I want to use).
    So I went and asked the person who made this sheet and he was like "I have NO clue m8". Turns out he didn't make this, just transcribed a little bit. The one who DID make it left the company (and the country altogether) in December.
    So now I'm like "How do I filter this so JUST the Agency name shows up".
    Of course, I could just use a query, so it shows the time difference (already done) and it shows JUST the name (the other thing I need). And I don't know jack about Excel, so if it's like the same formula or option, I don't have a clue.

  11. #11
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Maybe I should make a new thread? Just for ^that?

  12. #12
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Ok me answering again...
    Use a combination of these functions to extract parts of a string: Left, Mid, Right, InStr, Replace, Trim
    Use Access help or Google them
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  13. #13
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Oh bollocks.
    I'll be back in the afternoon then.

  14. #14
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    Nope. I'm too dumb.
    Gonna make a new thread after my lunch.
    For now, the question that started this thread is solved. So...

  15. #15
    TrulyVisceral is offline Total N00B
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2018
    Location
    Deimos
    Posts
    102
    I don't know if you heard that, but that was me FACEPALMING so hard, a type 8 earthquake started.
    The picture with the subtext "EXCEL filtered"?
    It's CALLED "Agencia" in that sheet of the excel file... BUT, it's actually pulled from the ID column in the raw data sheet, rather than the "Agencia" column...
    Why even have that column? MOST OF THE FIELDS ARE BLANK ANYWAYS!

    Sorry. Rant over.

    Click image for larger version. 

Name:	3.png 
Views:	6 
Size:	25.2 KB 
ID:	33395

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

Similar Threads

  1. Replies: 24
    Last Post: 07-28-2015, 10:50 AM
  2. Replies: 4
    Last Post: 06-05-2014, 02:24 PM
  3. Replies: 6
    Last Post: 02-29-2012, 03:13 AM
  4. Replies: 3
    Last Post: 01-10-2011, 10:31 AM
  5. Need Zero Values in Table For Graph
    By TexMax007 in forum Access
    Replies: 2
    Last Post: 06-02-2010, 10:02 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