good day all

[wiredgecko]

hello. i'm new to access and would like some assistance please.

i have a table and there are fields i am having problems with.
in particular, i have three fields; a date field labeled "Start Permit" another date field labeled "Permit Issued" and the third is a text field labeled "Pertit Status". here is what i am trying to accomplish:

if "start Permit" and "Permit Issued" are blank, then in "Permit Status" this statement should appear "Not Applied For"

if "Start Permit" is not blank and "Permit Issued" is, then in "Permit Stauts" this statement should appear "Waiting For Permit"

if "Start Permit" and "Permit Issued" are both NOT blank, then in "permit Status" this statement should appear "Permit Issued"

i've tried different IIF AND statements but without success.

Thxs

 

[mrmmickle1]

Try something like this:

Excel 2012
	A	B	C
1	Start Permit	Permit Issued	Permit Status
2			Not Applied For
3	5/5/2015		Waiting For Permit
4	5/5/2015	5-Jun	Permit Issued
5	5/5/2015	5-May	Permit Issued
6			Not Applied For
7	6/5/2015		Waiting For Permit
Sheet1

Cell Formulas
Range	Formula
C2	=IF(AND(A2="",B2=""),"Not Applied For",IF(AND(A2<>"",B2=""),"Waiting For Permit",IF(AND(A2<>"",B2<>""),"Permit Issued","")))
C3	=IF(AND(A3="",B3=""),"Not Applied For",IF(AND(A3<>"",B3=""),"Waiting For Permit",IF(AND(A3<>"",B3<>""),"Permit Issued","")))
C4	=IF(AND(A4="",B4=""),"Not Applied For",IF(AND(A4<>"",B4=""),"Waiting For Permit",IF(AND(A4<>"",B4<>""),"Permit Issued","")))
C5	=IF(AND(A5="",B5=""),"Not Applied For",IF(AND(A5<>"",B5=""),"Waiting For Permit",IF(AND(A5<>"",B5<>""),"Permit Issued","")))
C6	=IF(AND(A6="",B6=""),"Not Applied For",IF(AND(A6<>"",B6=""),"Waiting For Permit",IF(AND(A6<>"",B6<>""),"Permit Issued","")))
C7	=IF(AND(A7="",B7=""),"Not Applied For",IF(AND(A7<>"",B7=""),"Waiting For Permit",IF(AND(A7<>"",B7<>""),"Permit Issued","")))

 

[Joe4]

hello. i'm new to access and would like some assistance please.

I think mrmickle may have missed that this is an Access question, not an Excel one!

Permit Status should be a calculated field in Access (not a table field). That calculation would look something like:

Permit_Status: IIF((IsNull([Start Permit])) And (IsNull([Permit Issued])),"Not Applied For",
IIF((Not IsNull([Start Permit])) And (IsNull([Permit Issued])),"Waiting For Permit",
IIF((Not IsNull([Start Permit])) And (Not IsNull([Permit Issued])),"Permit" Issued,"Unknown")))

 

[mrmmickle1]

Joe4,

I did indeed miss that The good news is that I ended up learning something new about MS Access. This is similar to my question a few weeks ago that you answered as well:

http://www.mrexcel.com/forum/micros...culated-field-access-iif-statement-print.html

Thanks for helping me expand my MS Access knowledge!

 

[wiredgecko]

GREAT!!! I would have never gotten that on my own.

Thanks to all for the help. plus now I also have the formula for Excel as well. two birds with one shot.