| | |
|
|
|
Table to collect information |
|---|
| message from Dick on 6 May 2004 |
Can anyone tell me how construct a table that collects
and retains annual imformation like dues without
overwriting the previouse years entry.
I'm lost - and can sure use the help Thanks
|
| Graham R Seach replied to Dick on 7 May 2004 |
Dick,
Just add a date (DateTime) or Year (Integer) field to the table, and feed
the date (or year) to it when saving the information.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
"Dick" <anonymous@discussions.microsoft.com> wrote in message
news:989001c433aa$8b586720$a301280a@phx.gbl...
|
| MacDermott replied to Dick on 6 May 2004 |
Sounds as if you need a field in your table to identify the year of the
entry.
If you set its DefaultValue to =Year(Date()),
it should automatically fill with the current year when a new record is
created.
HTH
- Turtle
"Dick" <anonymous@discussions.microsoft.com> wrote in message
news:989001c433aa$8b586720$a301280a@phx.gbl...
|
|
Archived message: Table to collect information (MS Access Database)
