help pls

[jgipe307]

im have issues with printing a report from a table or form. the form has a expression in next epr to show a date 11 mths from the current epr date when i try a do a report the name just show but no date

View attachment tracker.zip

 

[John Big Booty]

Put the following expression in your Control Source for Next EPR;

=[URL="http://www.techonthenet.com/access/functions/date/dateadd.php"]DateAdd[/URL]("m",11,[Current EPR])

Might I also strongly suggest that before you progress too much (any) further with this project that you read up on and become familiar with the concept of Data Normalisation. Once you have done that you will realise that your current arrangement is far from normalised and is only going to lead you into a world of hurt.

You might also like to consider implementing a naming protocol for your database objects, something along the lines of TBL_TableName, FRM_FormName, QRY_QueryName, RPT_ReportName, avoid using spaces (which you are already doing ) and other special charters, and limit your self to alpha and numeric charters and the underscore. Your current arrangement with a table a form and a report all name Tracker, is once again leading you toward a very dark place. Consider that when you start to write code and you refer to the object Tracker, Which of the the identically named objects will you be referring to

 

[HiTechCoach]

Normally calculated values are not stored.

If you are performing a calculation ion the form then you should also perform the same calculation on the report.

Are you performing the same calculation on the report like on the form?

 

[John Big Booty]

Just to clarify my previous post and to reiterate HiTechCoach's point, the code I gave should go in the Control Source for Next EPR on either (both) your Report and/or Form.