need help/advice for a form yes/no visual indicator

[sumhungl0]

I am moving data/records from a "not so friendly" excel workbook into a hopefully better access product. this data is for jobs accomplished "on time" vs "late".
so the data is as follows:
EquipID, MaintAction, dateSched, dateComp, OnTime.

the data was imported into an access db, so I have all the history. I work on inputting these maintenance activities once every month and put out a report of the previous months results for management. basically it shows maintenance activities grouped together with totals of completed on time with a summary percentage.
on the old excel product, the OnTime column had this formula:

=IF(D2>C2,"NO","YES")

when I imported the excel data to access, I copied all columns. however I don't think I need to store a yes/no value in access. Thoughts?

so here is my idea, just don't know how to accomplish it in access. I made a continuous form that queries only records for the month im working on. I have my four fields above. how can I make an unbound field that will look at dateComp and dateSched to display a yes/no for each record? or do you think I should use a bound field for OnTime that would auto yes/no based on the date fields and store the yes/no values like the original excel data? if so, how would I auto yes/no that field on the form and update the records? I duno, the auto yes/no idea seems storage of useless data to me. what do you think?

any help is much appreciated, thanks.

 

[ranman256]

in access query its almost the same.
in a query field put
OnTime: [field1]>[field2]

 

[sumhungl0]

that's perfect. so do you think I should store these yes/no values or just calculate it as needed?

 

[Micron]

The general rule is that you do NOT store calculations. If any value is altered, either directly or by cascading updates or deletions using defined table relationships, the stored calculation is invalid.