Query Criteria Help

[Shell]

In Access 2000, I am trying to create a query with a strange criteria

I have a field in a form (frmReportingTool) named txtX.
I also have a field in the table named X.
When I have a value in txtX, the query works just fine. But in the case
where txtX ="", then I need the query to get ALL the data records not caring
about X. All values of X are needed.

IIf([X]="","",[forms]![frmReportingTool]![txtX])

What am I missing?

Thanks

 

[Dale_Fye via AccessMonster.com]

would help if you posted the query.

Assuming that txtX is an unbound textbox, what you need is something like:

SELECT * FROM yourTable
WHERE [X] = Forms!frmReportingTool.TxtX
OR Len(forms!frmReportingTool.TxtX & "") = 0

HTH
Dale

In Access 2000, I am trying to create a query with a strange criteria

I have a field in a form (frmReportingTool) named txtX.
I also have a field in the table named X.
When I have a value in txtX, the query works just fine. But in the case
where txtX ="", then I need the query to get ALL the data records not caring
about X. All values of X are needed.

IIf([X]="","",[forms]![frmReportingTool]![txtX])

What am I missing?

Thanks