Query By Form (Multi)

Hope someone can help here before i actually go grey with trying. I have a small form which has start/end dates, problem text searches, closed dates, PR's etc etc linked to a fault logging ODBC database. I want the user to be able to specify what results they want to see i.e.

All Calls that were logged between 01/01/04 and 17/11/04 - with SQL in the problem text and all PR1's.

Hope im making sense here.

I have create the QBF and the query which has the following criteria used:

For example Calls Opened = (txtStart_open) and (txtStart_End) Therefore Criteria should =

Between Forms![QBF]![txtStart_Open] And Forms![QBF]![txtStart_End] Or Forms![QBF]![txtStart_Open] Is Null

This criteria works on its own however when i add in {problem text search and pr} it just gives me all records back:

Problem Text Search =

Like Forms![QBF]![txtProb] & "*" Or Forms![QBF]![txtProb] Is Null

I thought i had this one sussed however me being me there is always a problem. Hope someone can shed some light on QBF using multi user searches.

Thank You

Nikki McInnes

Nikki,

I am not familar with syntax and sql server but don't you have to group your wild card?

Like (Forms![QBF]![txtProb] & "*") Or Forms![QBF]![txtProb] Is Null

or something along those lines
lwells

Dont think so with this syntax but i will give it a go, thanks

Nikki