Max function in calculated field

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / New Users / May 2005

Max function in calculated field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 16 May 2005 15:15 GMT

I have set a calculated field in a report. Max([Action.Date]+ 180).
This works fine in the report, but I want to change it to 6 months.

Would someone help me with this?

I do not know code.

Reply to this Message

Van T. Dinh - 16 May 2005 15:25 GMT

Try

Max(DateAdd("m", 6, [Action Date]))

Signature

HTH
Van T. Dinh
MVP (Access)

> I have set a calculated field in a report. Max([Action.Date]+ 180).
> This works fine in the report, but I want to change it to 6 months.
>
> Would someone help me with this?
>
> I do not know code.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.