Results 1 to 3 of 3
  1. #1
    ChrisCione is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    6

    How To Print Calculated Dates on Report

    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.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    have you tried to duplicate your date calculations in the report; using unbound text boxes just as you did with the form?

  3. #3
    ChrisCione is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2010
    Posts
    6
    Quote Originally Posted by NTC View Post
    have you tried to duplicate your date calculations in the report; using unbound text boxes just as you did with the form?
    I did after reading your reply. Works perfectly. Don't know why I didn't think of it.

    Thanks for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculated expression in report
    By Grizz2 in forum Reports
    Replies: 3
    Last Post: 12-20-2010, 08:50 PM
  2. Between Dates Report Problem
    By aamer in forum Access
    Replies: 4
    Last Post: 12-02-2010, 01:00 PM
  3. save data calculated, using query or report
    By victor in forum Programming
    Replies: 1
    Last Post: 08-03-2010, 08:49 AM
  4. Sorting a Report by a Calculated field
    By mulefeathers in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:21 PM
  5. Filtering Report with between dates
    By patrickmcdiver in forum Reports
    Replies: 3
    Last Post: 02-22-2010, 12:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums