Recent content by Thursday

I use a list box [NameSelect] on a form to populate a query criteria when I run reports. I've seen several posts on multi-select, but I can't comprehend the VBA portion. Is there a simple (non VBA or VBA for a neophyte) way to allow me to use multi-select to specify multiple (or single, or...

I dug through these discussions and found an item where I enter the criteria like this: like [nameselect] OR [nameselect] IS NULL When I saved and reopened my query design, it had added a new column called [nameselect] with IS NULL down in the criteria list. No clue why it worked (which is a...

Ok, new confusion... When I use two criteria in my queries (on separate lines, making them OR criteria), the criterion works if I use one or the other(one is on employee name, the other is on date), but it won't restrict my record search by name when I enter BOTH of the criteria (name and...

No further problem, I figured it out! Thanks for your help.

I'm afraid I don't understand what you mean. I understand how to get at the totals row in the field list, but which option to use (group by, sum, count, etc) and on which query (the incidents query with multiple records or on the calls taken query which has one record each) is extremely...

Actually, I tried that. It's difficult to describe how the dynaset comes out, but let me try: The first query has multiple entries for each employee, while the second query only has one entry for each employee. When I combine the queries, the dynaset repeats the entries from the second query...

I am attempting to create a calculated field that will take [res errors] from one report and divide it by [calls taken], which is produced in another query on another report. Even when I identify the query that [calls taken] comes from in the data source property, it prompts me for it when I...