Kumar- You can use the WeedDay function to find out the day of the week for any date. You could perhaps use this with the IIF function to generate what you want.
DayType: IIF(WeekDay([MyDate]) > 5, "Holiday", "Normal") 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 access_kri Sent: Monday, November 21, 2005 12:25 PM To: [email protected] Subject: [ms_access] Setting Default Value based on condition Dear All, Another question. I am developing a scheduler database. I want that to set [Day] field as "Holiday" if it is Friday or Saturday else "Normal" for working days. Request for your help. Regards, Kumar ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/eMf55D/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> 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/
