best training access course - recording date and time

Resolved · Low Priority · Version Standard

recording date and time

Sabine has attended:
Access Intermediate course

by - delegate Sabine [7 posts] (2007 Oct 23 Tue, 13:50) Reply

How can i record when a comment for a record is made, and how can i update this so that the history is kept but the most recent item is shown?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: recording date and time

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 23 Tue, 14:37) Reply

Hi Sabine

Thank you for your question.

As you can only store one value per field, what you could consider doing is creating a separate table to store comments and the date and time they were entered.

This table could then be linked to records in your existing table by creating a relationship between the existing table and the Comments table.

To view the comment history, you would need to create a subdatasheet in a table or a subform in a form or a query.

To show the last comment, use the LAST function.

I hope this helps.
Amanda

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· Microsoft Access Mistakes to Avoid
· How to Find a Third-Party Venue for Microsoft Access Training
· Microsoft Access and Customer Surveys
· Microsoft Access Courses

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Rate this page: