answersLogoWhite

0


Best Answer

the function to calculate the current date and time is "now()". to query the time you can type "<now()" or ">now()". to calaulate the difference, "now()-fieldname"

to insert the current ate and time into a record set the vb code "fieldname = now()" to the after_insert event

hope that helps

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How to link my dates in my Microsoft access table to the clock on my computer to produce an up to date difference in the date in my table?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What materials does Microsoft access produce?

A Database


Is Microsoft Access a computer application?

Yes.


How can you download Microsoft Word if you your computer cant access the Microsoft website?

You need to have access to another computer that can connect to the Microsoft site and download the redistribuable office trial package onto a memory stick and transfer it to your computer.


Who is the creator of the computer program Access?

Microsoft Access is a part of Microsoft Office. Microsoft Access was created by the Microsoft Corporation and it was first released in November, 1992.


Is Microsoft Access an example of personal computer's operating system?

No. Microsoft Access is a database application, not an operating system.


How can you move a Microsoft Access Application?

To A New Computer??


What has the author Sandra Cable written?

Sandra Cable has written: 'Microsoft Excel 7 for Windows 95' 'Excel 5.0 for Windows' 'Microsoft Excel for Windows Tutorial and Applications' 'Teach Yourself Access 97 Visually Student Workbook (Read Less, Learn More)' 'Microsoft Excel 7.0 for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Excel for Windows 95' -- subject(s): Business, Computer programs, Electronic spreadsheets, Microsoft Excel (Computer file) 'Microsoft Access 97 for Windows' -- subject(s): Database management, Microsoft Access, Microsoft Windows (Computer file) 'Succeeding in business with Microsoft Office Access 2007' -- subject(s): Business, Computer programs, Database management, Microsoft Access


What is the difference between Microsoft Access and powerpoint?

PowerPoint is for creating presentations. Access is for managing databases, which is usually done by businesses.


Is Microsoft access an example of a personal computer's operating system?

No. Access is a personal (small-scale) database system.


Are there any Microsoft access classes online?

You can get the ExpertRating Online Microsoft Access 2007 Course (more info at http://www.expertrating.com/certifications/InstructorLed/Computer-Applications/Intermediate-Microsoft-Access-2007/Intermediate-Microsoft-Access-2007.asp). Or you can try official Microsoft training, at http://www.microsoft.com/learning/en/us/training/format-online.aspx.


What has the author Pamela R Toliver written?

Pamela R. Toliver has written: 'MicrosoftT Office 2000' 'Select Lab Series: Microsoft Certified' 'Microsoft Excel Comprehensive, Volume I and II 2002' 'Ami Pro for Windows, release 3.0' -- subject(s): Ami pro, Desktop publishing 'Essentials' 'Microsoft Office 97 professional' -- subject(s): Business, Computer programs, Database management, Electronic spreadsheets, Microsoft Access, Microsoft Excel (Computer file), Microsoft Internet Explorer, Microsoft Office professional, Microsoft PowerPoint (Computer file), Microsoft Windows (Computer file), Microsoft Word, Presentation graphics software, Word processing 'Essentials Microsoft Office Access 2003 comprehensive' -- subject(s): Database management, Microsoft Access 'Projects for Microsoft Office 97 Professional' 'SELECT Series' 'Microsoft Access Comprehensive'


How do you save and edit Access documents on Yahoomail?

You can save any attachment to your computer. You will need Microsoft Access to actually open it.