Search results for query: *

1. I have several reports which have the "Day of the Week" as a selection parameter. I want to use the same "Day Selector Form" with an Option Group, then pass the selected day (from the Option Group) to the Report. Each of these steps works OK independently but not as a...

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...

Is the "New" module just created in the module area? How does Access process this module first to know that the "global variable" defined is used in another Form?

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.

Many thanks to VogonPoet. Someties a very simple answer and example is all that is needed. My grey matter at 70 needs a little stimulous, eventho I have been in the computer field since 1951. Thanks again.

Thanks pdldavis. I forgot to mention that I need to have a subtotal in each group footer. When I place the code as given to me, I get within each footer the same number, that number being the TOTAL of all of the item in the entire report. It seems to me that somehow Access is executing the over...

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

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

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...

Thanks Herb, but this does not solve my problem. I know I'm missing something simple. The result I want is to count the 'types' of DRINK in each group (this is for an application where meals are delivered on different routes. Thus, for each route (which is the group) I need to count the DRINK...

Correction: DRINK is used throughout, not DRINKS

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...