Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mattsuppok
  • Content: Threads
  • Order by date
  1. mattsuppok

    running a parameter query

    Can I set a command button that will populate a query parameter value box? And How??? Thanks in advance
  2. mattsuppok

    option value

    on an option radio button, that is part of an option group, is there a way to set the value to any text that you wish, so that that value can be stored in the table. It seems to not let you select anything but numeric values. Thanks in advance.
  3. mattsuppok

    subtraction in crystal

    Creating a report with values grouped by a field. The group is then summarized. There are only 2 values that will be grouped... What I want to do is instead of a grand total showing in the report footer, I want the difference between the 2 groups to show. Example Inlet total 500 outlet...
  4. mattsuppok

    crystal report columns

    want to take a report, make it look like an excel table like this... Jan. Feb. March. meter1 34 35 54 meter2 44 66 77 meter3 55 7 55 and so on... now, the meter field must be grouped, I can also group by date.. A cross tab will display this...
  5. mattsuppok

    excel database

    trying to extract data from a spreadsheet based on a field. I want to have the output of a filter go to a different file. I want to write this in VBA. Help??? can this be done.. I can't record the macro, too many records.
  6. mattsuppok

    averaging in queries

    I have three fields in a query and I want to add those three fields and create a column with the average of those totals. Some of the records will be null. What do I do? Simply creating an expression, "avg([field1]+[field2])" doesn't seem to work.. Please advise
  7. mattsuppok

    report control boxes

    I want to know if there is a way to supress a control box if there is no value for one record. I know how to make a blank appear with an IIF statement, but this is not what I need. I need to eliminate the blank space. Thanks in advance.
  8. mattsuppok

    access report summary

    How do I place a field on a report that will place a grand total for ALL the records in one field on the query? I have several grouping levels already and I open the report with parameters in my query criteria. Thank you for any help...

Part and Inventory Search

Back
Top