Search results

interesting. my query works. It returns a N value when there is no date in the documentreceived field but a #error when there is a date

I am sure this has something to do with the fact that it is a date field with a valid date in it that produces the #error. Am I asking the expression to change a date value to a string value?

it gave an n to all records even when there was a date

Brian, thanks for the response. By changing to 1 my iff statement stopped working all together. right now it is working it is just adding #error to the yes piece

thanks very much Paul for all of your help. Attached is a db with some info. The query is where you will see that it is returning the correct value if the date field is null but not if there is a date in it. I am wondering if it has to do with strings or something.

almost working okay. I almost have it working. Here is my nested iif: Expr3: IIf([DocTypeID]="1" And IsNull([documentreceived]),"N","Y") "1" represents script For all dates that are null my expression is returning N. for all that has dates it is returning #error. Any ideas?

doesn't the isdate convert a function to a date? My documents received field is already a date field. I just want to check if it is null or not

I tried changing it to 2. I think what it doesn't recognize is the isdate date received.

I cannot because the info is confidential. Let me try it this way: document table has two fields: doctypeid - will either be script, result, or approval document received - date field showing one of the three above is received query is looking for: if the doctypeid is equal to result...

yes, I changed the field names. It returns an error

no. the date field is called document received and it either has a date or is empty. What I want to show is this: field: doctypeid - if doctypeid = result and if field: document received is not null, then "y" else (show nothing) does that help?

I have a field called doctype. this field has three values: script, result, approval. They are all considered documents. When a script comes in it is marked as script and given a document received date. When a document comes in that is a result it is tagged as result and given a document...

what is a switch function and how would that look? I want the function to look at doctype and see if it matches result. if it does I then want it to look at doc received date to see if it has a date; if it has both result and date I want it to return yes. How would a switch do that...

thanks again to all who helped earlier. The if statment (Expr3: IIf(IsNull([document received]),"No","Yes") worked great! Now I need a nested if statement. It needs to read if doctype equals result and if document received isnotnull, then yes else no how would that look?

never mind..figured that one out too. Thanks all of you for your help. This site is awesome

ok. I figured out why it was prompting me for a parameter value. Now it is returning a -1 though. Any thoughts?

thank you for your response. I just tried it and it is asking me to enter a parameter value

thank you. I apologize for not providing enough info. I actually want to build the if statment in an append query. Can you help me with that?

I have a documents table with a date field titled "datereceived". I have a second table with a checkbox field that indicates if the document has been received. (we need to track these metrics) I need an if statment that says if date received is null, then no in checkbox field, else yes...

Thanks. But I actually have to track the cycle and with each document received the life cycle is given a percentage complete. For example: if a script is received then the cycle is given 30 points if a result is received then the cycle is given 30 points if an approval is receieved then the...