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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |