Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graph Format via Rowsource (2000)

    Hi,

    I have a graph with the following rowsource:

    <code>SELECT (Format([DateField], "ddddd")),Min([ServerSize]) AS [M
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Format via Rowsource (2000)

    Since I'm lazy, could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Format via Rowsource (2000)

    Hi Hans,

    There goes the stripped down version. The tblSizeLogger_Matriz table is actually a linked table, so it does update daily.
    The form containing the graph is frmGraph. You'll note the field names aren't as I typed them in my previous post; there, I had renamed them so they would be easier to understand.
    The graph's rowsource is established via VBA whenever
    a) the form opens; or
    [img]/forums/images/smilies/cool.gif[/img] an item is selected in one of the combo boxes.
    In that respect, the VBA code uses the same standard SQL syntax that Access created when I first inserted the graph (the one with the "ddddd" format). I'd do the VBA recoding myself; the only thing I need to know is how to establish the rowsource (in terms of SQL syntax).

    Thank you
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Format via Rowsource (2000)

    As long as MS Graph recognizes the x axis values as dates, it will automatically use a time scale axis. So you *must* use a format that is not recognized as a date format, for example ""dd~mm~yyyy"" or ""ddmmyyyy"" or ""dd mm yyyy"" <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  5. #5
    5 Star Lounger
    Join Date
    Mar 2002
    Location
    Buenos Aires, Argentina
    Posts
    877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Format via Rowsource (2000)

    Perfect. My choice: "dd.mm.yyyy" <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    So what I wasn't able to distinguish is that on one hand, Access uses its SQL engine to format the field; on the other hand, Access has MS Graph draw the chart. AND the way MS Graph draws the chart is dependent on the format of the data.

    Thanks so much!
    <img src=/w3timages/blue3line.gif width=33% height=2>
    <img src=/S/flags/Argentina.gif border=0 alt=Argentina width=30 height=18> <big><font color=4682b4><font face="Comic Sans MS">Diegol</font face=comic></font color=4682b4> </big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •