Text Message in Query

[andthe]

I'm fairly new to Access and would appreciate some help. I have a query that contains PART, BUYER, PO, BEG_DATE, END_DATE, REQD_DATE. I want all of these fields displayed, but I also want to create a new column called ERROR. If the BUYER = 99 or the BEG_DATE is overdue or the END_DATE is overdue I want the field to display "ERROR - CHECK STATUS". How do I do this within Access? Thanks!!

 

[Philem]

Hullo! Try something along these lines:

Error: Iif(BUYER=99,"Error - Chech Status",Iif(BEG_DATE>overduecalc,"Error - Check Status",Iif(END_DATE>overduecalc,"Error - Check Status",Null)))

The phrase "overduecalc" is whatever logic you are going to use to determine overdue status. That should get you started.

HTH

P

 

[Joe4]

Create a calculated field in your query with a formula something like:

ERROR: IIf(([BUYER]=99) Or ([BEG_DATE]<Now()) Or ([END_DATE]<Now()),"ERROR - CHECK STATUS","")

Simply paste this code in a blank Field box in Design mode of your query.

I am checking the dates to see if they are before today. You may need to modify that calculation depending on what your conditions for "past due" are.

 

[andthe]

This worked great! Thanks for all of your help!!