Search results for query: *

The technique you need is called QBF (Query by Form). You create an unbound form with unbound text boxes for the user to type or select (from combo box) whatever is to be the criteria for the report. The report is based on a query that includes the criteria from the report. The query might have...

Check your query in datasheet view. If no data appears you need to rework the query. If the query shows data, so will the form.

Sorry, all I know is what I read in the Knowledge Base.

Check out the following link for detailed answer: http://support.microsoft.com/default.aspx?scid=kb;en-us;208714

For each Yes/No field in the query you wish to total, type: (Alias Name): Sum([Field Name]* -1 Yes/No fields are binary, either on/off, true/false, etc. The value is stored as -1 for True. When you sum this field the No's don't count because they have a value of 0. The *-1 at the end converts...

Here's one way to accomplish what you want. 1. Create a parameter for the Year field in your query, such as: [Enter Year] Show is checked. 2. Open a blank field in the query called [Enter Year] In the 'criteria' row type Is Null In the 'or' row type Is Not Null Show is not...

You can create multiple GROUPS to store them in.