Include all search.

[prodtest]

I have a query which searchs a stock database table based on certain criteria. One of the criteria is a combo box that lists all types of transactions i.e stock in, stock out etc. I can get my query to return results based on transaction type between two dates, but I need to be able to return all transaction between two dates. Is there a wildcard I can use to ignore the transaction criteria.
Hope this made sense !!

 

[ormsk]

Hi

I'd be inclined to add an 'All' criteria to your list box e.g.

[All]
Stock In
Stock Out

That would mean more to your users

Then when you are building your query statement, just leave out the part that filters by the transaction type when the combo selection is [All].

 

[PHV]

WHERE ... Nz([transaction type]) Like Nz([Forms]![form name]![combo name],"*") ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244