Displaying 2 results in one field

[chrisd49]

Hi All

Is it possible to display two result in one field.
In essence i have a table of tasks with a due date.
I would like to display a count in red of overdue tasks in reference to the current date and a count in green of the tasks which are after the current date. The date is based on month year.

I think I may have to have two seperate fields and make them look like one by having no outlining but if its possible i would rather do it in one field.

My knowledge of VB etc is very limited but I can follow code and sometimes adapt it successfully.

Any help much appreciated.

ChrisD

 

[boblarson]

If you can get everything into one query for the form, you can just concatenate the two fields in the text box.