how to insert multiple conditions/criteria for a field.

mahsa878

New member
Local time
Today, 07:03
Joined
Jul 24, 2013
Messages
7
I am trying to make a query that outputs the minimum "Need Year" AND ALSO if the need year was equal to 9999 it shows "NO DATA". I don't know how to do it, please help!
:confused:
this is what I have so far for checking the minimum value:
field: Need Year: MinofList(PMS_output!pqi_ny,PMS_output!iri_ny,PMS_output!sdi_ny,pms_output!sai_ny)

I am not sure if I should be putting it in the criteria to check whether this minimum value (need year) equals to 9999 or not and if it does, it says "NO DATA" instead of 9999.

Thanks
Mahsa
 
Last edited:
You don't put it in the criteria. I think you mean parameters but what is the function MinofList anyway? That doesn't sound like a built in function of Access. If you have the code for it, post it.
 
You don't put it in the criteria. I think you mean parameters but what is the function MinofList anyway? That doesn't sound like a built in function of Access. If you have the code for it, post it.

it is a built in for Access 2010, there's MinofList and MaxofList
 
it is a built in for Access 2010, there's MinofList and MaxofList
Do they accept NULL values? If not, you may need to wrap the NZ function around the parameters you are passing.
 

Users who are viewing this thread

Back
Top Bottom