Query returns no results

[systemx]

Hi all,

I think this could be another one of my stupid moments. Here is my query expression -

IIf([WHAT TEAM?]=1,[strCurrent_Team]="FINANCE",[strCurrent_Team]<>"FINANCE")

When run, the user is prompted to enter a team number. If they enter 1, then by my reckoning the query should return all records where [strCurrent_Team] = "Finance".

However, no records are returned.

strCurrent_Team is formatted as text.

Can anyone tell me what I am doing wrong here?

Cheers,

Rob

 

[pbaldy]

Where exactly do you have it? What does the WHERE clause look like?

 

[systemx]

It's OK. Confirmed. I am an idiot.

I had it under the criteria for the field, instead of in a seperate expression.

All fixed.

 

[The_Doc_Man]

Just a reminder, and only a techie nit-pick at that:

A query that doesn't return an error-type message box ALWAYS returns an answer. Sometimes that answer is the null set.

Whenever you run a query that doesn't seem to return anything, your issue is almost always incorrect, intractable, or overly selective selection criteria. As in this case, where you had an incorrect thing in the Criteria row.