If function in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made an if function which is not working. I have tried both the
expressions below.
=IIf(>5,"Stock level OK","Order more Stock")

=IIf([No in Stock]>5,“Stock level OKâ€,“Order more Stockâ€)

If the field which is called No in Stock is more than 5, I want the field to
display Stock level Ok. If it's less than 5 I want the field to display
Order more stock.

Can anyone help?
 
If this is in a query and you are using the query grid then try.

Field: Stockorder: IIF([No in stock]>5,"Stock level OK","Order more Stock")
 
Chantelle said:
I have made an if function which is not working. I have tried both the
expressions below.
=IIf(>5,"Stock level OK","Order more Stock")

=IIf([No in Stock]>5,"Stock level OK","Order more Stock")

If the field which is called No in Stock is more than 5, I want the field
to
display Stock level Ok. If it's less than 5 I want the field to display
Order more stock.

Can anyone help?
Click to expand...
If you're making a control on a form or report with the above formula as its
source, make sure the name of the control is NOT [No in Stock]

Tom Lake
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting rid of a Having clause 1
Checking values in different fields. 1
Want stock to update in stock table when order is made in order ta 1
Access Stock In Hand query in access 2007 0
Query returning duplicate/unexpected results 3
Excel IF function in excel 2
Subquery help PLEASE! :P 2
combo box with query to update its data 1

Back
Top