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 bkrike 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: 3734kumo
  • Content: Threads
  • Order by date
  1. 3734kumo

    Called macro from a form only executes the first command

    A button on my form executes a macro. In the Macro section, I entered a Macro Name say M1. Under Action, I have the OpenForm & then filled in below the desired paramters. On the next line, I leave the 'Macro Name' blank and under 'Action' I have, say OpenReport with also the paramters filled...
  2. 3734kumo

    Passing Querys to the same report

    I have several record selections all of which use the exact same report. How do I change the record source of the report? I want to use a form to select the desired set and on 'click' pass it to the report. It seems so easy in other languages. I don't know why I can't see it in the books.
  3. 3734kumo

    Conditional Counting Logic & IIF vs IF

    Hope for any help on the following: If I wanted a count of records based upon a value in an other field, would the statement in the text box look like: =if xfield = 1 then count(*) Also, I see both IF and IIF used: what is the difference? Thanks for any help
  4. 3734kumo

    Calculating sub-totals of a text-content field in a report

    I need to count the occurance of specific text words in a given field. There are a finite number of words, so I can do a compare and then increment the proper counter. DCount does not work since I am not sure of the syntax. I do get numeric values, but they do not relate to my problem. Also, if...
  5. 3734kumo

    Understanding DCount() Syntax

    I am designing a report with group levels and the sum() function works just fine. It is in group-footer & resets for each group. I need to count the occurrance of specific TEXT in a field, say DRINK in file CLIENTS within each group. There are a finite number of drinks, such as JUICE MILK etc. I...

Part and Inventory Search

Back
Top