I have an unbound text box (called "Due Date") on my form which calculates a due date of a project based on two factors, both of which are fields in the db: the type (selected from a combo box) and the Date I was assigned the project. The field names are "Type" and "DateReceived".
The control source of the unbound text box is:
Code:
=Switch([Type]="Difficult",DateAdd("m",2,[DateReceived]),[Type]="Standard",[DateReceived]+10,[Type]="Complex",DateAdd("m",3,[DateReceived]))
A "standard" assignment is due in 10 days; "difficult", 2 months; "complex", 3 months.
It works beautifully.
How can I get this information to print on a report? I have multiple records (projects) assigned on different dates, so naturally each project has its own due date.
An early thanks for any assistance.