|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 17th, 2005, 07:20 PM
|
|||
|
|||
Calculated fields
How do I get a field to calculate a date 60 months in advance of another
date field. I can do it in Excel but not in Access. Thanks Dave 
|
|
#2
January 17th, 2005, 08:07 PM
|
|||
|
|||
|
Stig wrote:
How do I get a field to calculate a date 60 months in advance of another date field. I can do it in Excel but not in Access. Thanks Dave That's because you don't do calculations in tables. Use a query, form, or report and put the calculation there. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com
|
|
#3
January 17th, 2005, 09:20 PM
|
|||
|
|||
|
On Mon, 17 Jan 2005 19:20:28 -0000, "Stig" wrote:
How do I get a field to calculate a date 60 months in advance of another date field. I can do it in Excel but not in Access. Use a Query; in a vacant Field cell type FutureDate: DateAdd("m", 60, [datefield]) and then use this Query as the recordsource for a form or report. John W. Vinson[MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sum Calculated Fields | jped | General Discussion | 1 | December 28th, 2004 11:07 PM |
| Criteria on field calculated form another calculated field | Max Moor | Running & Setting Up Queries | 1 | December 22nd, 2004 08:19 AM |
| Calculated Query Fields Using DateDif Function | Bill Hamill | Running & Setting Up Queries | 6 | September 24th, 2004 05:17 PM |
| Problem with calculated controls with data from subforms | Ragnar Midtskogen | Using Forms | 8 | July 25th, 2004 07:18 PM |
| [Modules] Updating Calculated Fields ? | Nico | Using Forms | 3 | June 16th, 2004 10:31 AM |
Linear Mode
