Task list

[Jim]

Hi,

Access 2007 newbie question.

I have a table with a field fldDueDate of type Date/Time that contains
a due date for tasks.

I would like to display this field and another field called fldName on
the switchboard form, but only display the records where fldDueDate is
less than (say) one month in the future.

This would enable me to see tasks due in the next month at a glance on
the switchboard form. I realise I can just create and run a query, but
it would be useful to have this information on the switchboard form.

How would I go about this?

Thank you for your time.

Jim

 

[John W. Vinson]

Hi,

Access 2007 newbie question.

I have a table with a field fldDueDate of type Date/Time that contains
a due date for tasks.

I would like to display this field and another field called fldName on
the switchboard form, but only display the records where fldDueDate is
less than (say) one month in the future.

This would enable me to see tasks due in the next month at a glance on
the switchboard form. I realise I can just create and run a query, but
it would be useful to have this information on the switchboard form.

Do create a query, with a criterion on fldDueDate of

< DateAdd("m", 1, Date())

to get just the next month's data; then base a Form on this query, and put it
on the switchboard form as a Subform (with no master/child link field).