Query field to show YES or NO based on two figures in other fields (1 Viewer)

YNWA

Registered User.
Local time
Today, 19:55
Joined
Jun 2, 2009
Messages
905
Hi,

I have 2 fields, days to complete and days allowed.

I need a field in my query to show a YES or NO answer if the days to complete field is equal to or less than the days allowed field.

Thus showing me which records were completed on time and which records were not completed on time.

How is this possible? I am using design view for building queries.

Eg. DaysToComplete 5 / DaysAllowed 5 / I want new field here to says YES as it was completed within the allowed 5 days.

Eg. DaysToComplete 3 / DaysAllowed 1 / I want new field here to says NO as it was not completed within the allowed 1 day.

Anyone?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 12:55
Joined
Aug 30, 2003
Messages
36,118
This type of thing:

NewFieldName: IIf(Field1 <= Field2, "Yes", "No")
 

Users who are viewing this thread

Top Bottom