I am developing a application using this fields as required by the
company.
1. Date Login
2. Time IN
3. Time OUT
My question is how to produce the number of days with 1 entry of Date
is the entry ? [Date Login]
Then, after getting the number of Days. Switching is needed for
weekdays and sundays. Note that if the Date is Sunday and that Sunday
does not pass 6 days from the previous Date Login, That Sunday will be
consider as WeekDay otherwise remain as Sunday.
How will I do That ? I already have this field in my query.
WkDay:IIF(Format([Dated],"dddd") <> "Sunday",1,0)
My only problem here is Sunday ’coz I cannot use this query:
Sunday:IIF(Format([Dated],"dddd") = "Sunday",1,0)
Although this will give a value 1 to my Sunday Remark field but it is
not the one required by my Boss. Read my 1st statement above in able
to figure out what to do ’coz I am also reviewing my work here though,
I can’t figure it out yet. Can you help ? I need it ASAP. Thanks
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/MS-Access-co...ict177868.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=597740