2 Form Questions for the Group...

Question 1:

Is there a command that will allow me (in queries for example) to match the
conditions of one field to that of multiple fields or values? For example,
in another data analysis tool I have used in the past, I could use
Match([Primary Search Field], [Condition 1], [Condition 2], [Condition 3]).
In other words, using this command, I could eliminate the need for multiple
"iif" commands. Anyone know the function?

Question 2:
I have a form with list boxes that I am using to select filter criteria from
before running a query. Within the query, I am using these commands:

[Forms]![Form1]![Employee Name] Or [Forms]![Form1]![Employee Name] Is Null

When I change the list boxes on the form to allow to me select multiple
filter criteria (such as two employee names), it will bring back all of the
records. How can I modify the command to filter (within the query) on the
two employees selected in the form?

Thanks - and to the regular posters, you guys are great! I have learned a
ton from each of you.

Peter Leman
.

Relevant Pages

  • RE: Form For Crosstab Query
    ... My next step is to place the query on a continuour form, and add a command ... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ...
    (microsoft.public.access.forms)
  • Re: Grouping Multiple Side by Side Columns
    ... "The command can't be performed with multiple sections ... "Bob I" wrote: ... sam wrote: ...
    (microsoft.public.excel)
  • Re: Bash commands: maybe they want to drive us crazy?
    ... Here is the man page SYNOPSIS for grep, ... be multiple files with /grep/. ... >format of any command. ... It is very difficult to run a command ...
    (comp.os.linux.misc)
  • Re: Select Email Adress using Check Box
    ... You can either use individual checkboxes for each email address, or a listbox that allows multiple selection. ... If the emails are each a row in a form, make that form a subform and put the command button on a parent form. ... and then export them into the "To:" adress bar in a new Microsoft Outlook ...
    (microsoft.public.access.formscoding)
  • Re: Printing to file with more than one page
    ... I have 27 figures and I need to print them to .pdf file, ... I know, how to print on one page with command "print", but I can't find, how to print on more pages. ... You could use the subplot command to put multiple plots on one figure. ... storing handle of each in the figs ...
    (comp.soft-sys.matlab)
Loading