ABK: FinancialYear: Year(DateAdd([JoinTime], 7, "m"))
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Abu Bakkar Khan Chowdhury Sent: Wednesday, January 04, 2006 9:17 PM To: [email protected] Subject: [ms_access] Date Hi This is my first mail in this group. I have a problem to solve. Please help. I hv a table called userdata. Fields are (with some example): Name address jointime position ABC 01-01-2001 CSO CDE 08-01-2002 CEO EFG 01-03-2003 My financial year is June-May. I want to make a query wehre I would like to find out the joining time of an employee in my financial year basis. Example: ABC joined 08-01-2002 it will be shown in financial year 2003. Pls help REGARDS ABK Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
