AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question My unique key is today's date. Is there anyway I can have it automatically add days. As it adds days I also need it to write the weekday on the second column.
Thanks.
Answer I'm not sure what you mean by add days. Can you be more specific. Or check out the DateAdd function, which may do what you want.
You do NOT want to store the Weekday in your table. As a general rule we do not store calculated values and weekday is a calculation based on a date. If you want to display the weekday on forms or reports, just set a control's data source to: