|
| 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 19th, 2005, 07:47 AM
|
|||
|
|||
use query to find age
i have a database and need to use a criteria to calculate the age for all the
fields already in the table/database, does anybody know what code i should use? many thanks 
|
|
#2
January 19th, 2005, 10:17 AM
|
|||
|
|||
|
"paul_88" skrev i melding ... i have a database and need to use a criteria to calculate the age for all the fields already in the table/database, does anybody know what code i should use? many thanks Try Age: DateDiff("yyyy";[Born];Date()) Svein
|
|
#3
January 19th, 2005, 01:26 PM
|
|||
|
|||
|
unless there is a time stamp for the record or each field,
there is no way that you can calculate the age of the fields. if there is a time stamp then in the query header put AGE  ate()-[TimeStamp]-----Original Message----- i have a database and need to use a criteria to calculate the age for all the fields already in the table/database, does anybody know what code i should use? many thanks .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unmatched Query Mess | Natalia | Running & Setting Up Queries | 8 | October 28th, 2004 02:36 PM |
| Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
| Find and Replace Query with Wildcards in Access | GoFlyersCS | Running & Setting Up Queries | 6 | October 18th, 2004 01:23 PM |
| Query Help find match and delete. | Raj | Running & Setting Up Queries | 1 | September 24th, 2004 09:16 PM |
| Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Linear Mode
