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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. Imconfused

    Sum in a Footer Text Box

    Thanks a million
  2. Imconfused

    Sum in a Footer Text Box

    How would I get the end result of the running sum to appear in the report footer?
  3. Imconfused

    Sum in a Footer Text Box

    I have been able to get the correct result by setting up a running sum text box for each group. The report is actually a few hundred pages long as there are about 36,000 records. However, this is quite cumbersome looking and does not provide for a professional looking report that provides the...
  4. Imconfused

    Sum in a Footer Text Box

    I'll try to explain this the best I can hoping one of you can help. I have created a report that groups records based on a common reference. In some cases, the group may contain 1 record or it may contain 100. Each record has different field values, many of which are dollar values. Within...
  5. Imconfused

    Sort/Group Question

    Hence, my name: I'm Confused But it worked just fine, thanks for the help, this is a lot better than trying to figure it out by reading "Access For Dummies".
  6. Imconfused

    Sort/Group Question

    Les, I'm not sure I understand. Is this an expression?
  7. Imconfused

    Sort/Group Question

    I need to perform a sort within my query or create a sub query that performs the needed function. Within a particular field, each record contains a 5 digit numeric value. I need to sort/group this field based on the last digit of the numeric value of each record. I feel like I may need to...
  8. Imconfused

    Help with comparisons

    Thanks, I finally got it to work using a combination of all of the suggestions. I had to use the Nz function in the JOQ Dollars field to convert the nulls into "0". Once that worked, everything else fell into place.
  9. Imconfused

    Help with comparisons

    I take that back, it did work except where there was a null value in some of the records (in one field). For the first several hundred records, the JOQ Dollars was null.
  10. Imconfused

    Help with comparisons

    Well, the query accepted the expression, however, no values are being displayed (I did check the "show" box). Below is the expression with the actual field names. BTW, thanks for your time. IIf([Inducted Dollars]>=[JOQ Dollars],[Inducted Dollars],[JOQ Dollars])
  11. Imconfused

    Help with comparisons

    The table I am querying is very large (approx 38,000 records). Many of the fields contain certain values (dollars). Some of the fileds are reporting values that should match the value in a separate filed (within the same record). For reporting purposes I need to use the value in field...
  12. Imconfused

    Help with comparisons

    I am trying to build a query that will compare values in 2 different fields then display the greater value. Any ideas?

Part and Inventory Search

Back
Top