"John Spencer" wrote:

> I would try:
>
> Adding to the IIF statement.
>
> (((EmployeeQry.Tuesday)=IIf(Format(Date(),"dddd")='Tuesday',True,False)))
>

>
> Or even simpler, drop the IIF statement
>
> EmployeeQry.Tuesday= (Format(Date(),"dddd")='Tuesday')
>

> IF that still fails then try reversing the logic of the test. Just in
> case SQL server is storing the data as 1 (True) and 0 (False).
>
> EmployeeQry.Tuesday =IIf(Format(Date(),"dddd")<>'Tuesday',False, True)
>

> By the way "..., but does not work now." is not very descriptive of the
> problem. Does that mean, you get the wrong results, no results, an
> error, different results than expected at times, a syntax error or ...?
> Please try to be a bit more specific in describing the problem.
>
> '====================================================
> John Spencer
> Access MVP 2002-2005, 2007
> Center for Health Program Development and Management
> University of Maryland Baltimore County
> '====================================================
>
>
> Steve Happ wrote:
> > Hello:
> >
> > I just upsized an Access 2003 application to a SQL Server 2000 back end.
> > There is a query that worked fine before the upsize, but does not work now.
> >
> > The purpose of the query is to give me a list of employees that are
> > scheduled to work today. The employee master row has 7 checkboxes for the
> > days of the week.
> >
> > Here is the SQL for the query. Can someone tell me how to make this work
> > with the SQL Server BE?
> >
> > SELECT EmployeeQry.EmpID, EmployeeQry.EmpLast, EmployeeQry.EmpFirst,
> > EmployeeQry.EmpSSN, EmployeeQry.EmpDept, EmployeeQry.Monday,
> > EmployeeQry.Tuesday, EmployeeQry.Wednesday, EmployeeQry.Thursday,
> > EmployeeQry.Friday, EmployeeQry.Saturday, EmployeeQry.Sunday
> > FROM EmployeeQry
> > WHERE (((EmployeeQry.Monday)=IIf(Format(Date(),"dddd")='Monday',True))) OR
> > (((EmployeeQry.Tuesday)=IIf(Format(Date(),"dddd")='Tuesday',True))) OR
> > (((EmployeeQry.Wednesday)=IIf(Format(Date(),"dddd")='Wednesday',True))) OR
> > (((EmployeeQry.Thursday)=IIf(Format(Date(),"dddd")='Thursday',True))) OR
> > (((EmployeeQry.Friday)=IIf(Format(Date(),"dddd")='Friday',True))) OR
> > (((EmployeeQry.Saturday)=IIf(Format(Date(),"dddd")='Saturday',True))) OR
> > (((EmployeeQry.Sunday)=IIf(Format(Date(),"dddd")='Sunday',True)));
> >
> >
> > Thanks
> >
> > Steve