Search results

I would like to run my query, but have it open into form view- any suggestions? *I don't want filter by form, or query-by-form, I want the info that would come up for the query, "MsterQry1", to be shown in the form. Thx~

I'm running a 9 parameter query, where values for the criteria are drawn from a form. I'm confused as to how I build an "if, then" string so that if one of the parameters is left blank, the program will skip it and go to the next. Any suggestions?

Multiple Query Issues Ok, I have a DB of client contacts. I'm drawing the values for a query from a form using [Forms]![Sort]![Contact] in criteria and using the parameter field to give values to each. The query works fine for state, contact and industry- all in conjunction with each other...

I just started using Access a couple weeks ago. I bought a couple books, have read some help stuff in forums webwide, but I am still stuck on the basics of how to do the following~ Please Help ~ My DB: I have a single main table, in addition there are several mini-tables used to support combo...