How to make blank fields NA

[jenncivello]

have a query with 104 different products. i want to set parameters for different products.

e.g if field C is blank make it NA. Can i set several different parameters for more than 1 product?

[burrina]

Don't know what you mean by NA? Yes, you can set more than one parameter per product. Please explain in detail what you are trying to do.

[jenncivello]

I have a form for several products, and i want to make certain fields "NA". If product A needs to be mixed fill out all fields, if product B only needs to be packaged, mark the mixing fields as "NA".
Does that make sense?

[Bob Fitz]

Is there a field to indicate which products need to be mixed

[June7]

This is a form, not report? You want data pre-populated based on criteria? You want to prevent user editing those fields? How do you 'know' product A needs to be mixed?

[jenncivello]

yes there is.

[jenncivello]

Yes, it is a form because there are several people in the department that would be filling it out. So i have the 1st field as the product name, then based on what product you pick, it will either leave the fields blank for you to enter the information into or it will NA the fields that don't need to be filled out.

[June7]

How do you 'know' product A needs to be mixed? What is the rule for populating field with "NA"?