Michael Brosdorf
michael.broesdorf at web.de
Mon Jul 19 09:36:59 CDT 2004
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