Kaup, Chester A
kaupca at chevrontexaco.com
Mon Jul 19 10:22:48 CDT 2004
Selected year contains the value 2004. It can contain any year value from 2001 to 2010 depending on what the user selects from the list box. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7414 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Michael Brosdorf Sent: Monday, July 19, 2004 9:37 AM To: Access Developers discussion and problem solving Subject: AW: [AccessD] Date format problem What exactly does the field 'selected_year' contain? Michael -----Ursprungliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Kaup, Chester A Gesendet: Montag, 19. Juli 2004 15:45 An: accessd at databaseadvisors.com Betreff: [AccessD] Date format problem The following expression in a query returns 2004 Test:[Forms]![frm Select Date]![selected_year] The following expression returns 05 in a query Test:Format([Forms]![frm Select Date]![selected_year],"yy") I an confused as to what is happening here. Help please. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7414 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com