Conditional Expression help

[Guest]

I have a table with 5 fields linked to another table. Fields 1 - 4 have
variable information in them and field 5 has the data I want to display. So,
basically, I need to tell it to meet certain conditions in the first 4 fields
and display the data in field 5.
Here is what data is in each field:
Field1 - either B or F
Field2 - RU,RV,N1,NC,NH
Field3 - (13 different numbers), ex: 1,2,3,4,5...
Field4 - (various number ranges), ex: 1-2,3,11-12,13-15...
Field5 - (Various numbers), ex: 73.0,92.0,91.0...

So, I need it to do something like, If Field1 = B and Field2=RU and Field3 =
4 and Field4 = 11-2, then display Field 5.

Is this possible?...I appreciate any help someone could provide.

 

[Guest]

Create a new query in design view. Drag each of the five field down to the
grid row labeled Field and uncheck the Show box for the first four. Enter
your criteria for each field in the grid row labeled Criteria.
Save the query and then run.

 

[Jeff L]

All you do is put the values you want in the criteria. For your
example, your criteria would be for:
Field1 - "B"
Field2 - "RU"
Field3 - 4
Field 4 - "11-12"
Field 5 criteria you'd leave blank.

Hope that helps!