Search results

  1. G

    Creating an "Average" expression

    I am trying to return all values or both Null and 99 as 0's and then average the 5 fields in the query by the number of fields that have data greater than 0. My original expression...
  2. G

    Radar/Spider Chart on Form

    My supervisor has tasked me adding a radar/spider chart to a database but I'm unsure how to do this. I found the Microsoft Graph Chart in the Unbound Object Frame. Is this where the radar chart is found? The radar chart will be filtered ID on the form and he wants the chart to display that...
  3. G

    Ignore text in query expression.

    I tried searching the forums for this but can't seem to find it. I have a table that has data as a text field. The data will be Numeric, Null or "N/O" as being "Non-Observed". My query expression works if the data type is numeric (without the "N/O"'s). However, I can't seem to figure out how...
Back
Top Bottom