Search results

Yes. WeekDay(calls.[opened date])<=7

Could you post an example of the SQL statement? I suspect it has to do with not having a where clause or group by in the SQL.

Ok... I would use DateDiff DateDiff("m",[Employee Master File].[Hire Date],Date()) = 11 This will give you all the employees that have a hire date that is within the 11 month window. Hope that helps. Jeremy

The value of checkboxes are -1 and 0. If the checkbox is checked, it will be -1. Therefore, try: IIf ([Forms]![frmLMBSearch]![txtTitle]=-1,[Forms]![frmLMBSearch]![txtTitle]& "*" ,"*") I hope that helps. Jeremy

If you wanted to return all the monday's then you would do this... Note, the Weekday function considers Sunday as 1, Monday as 2, etc...

Or... SELECT Count(SELECT DISTINCT [All gages].[DATE DUE] FROM [All gages] WHERE ((([All gages].[DATE DUE]) Between #3/1/2008# And #3/31/2009#))) FROM [All gages];

Are you trying to pull employees with an "exact" one year anniversary?

Try putting a ";" at the end of each SQL statement. When parsing SQL, you have to let the system know you will are sending multiple SQL statements. Even with UNION, MS Access considers the SELECTs two seperate SQL's. SELECT SalespersonID, Sum([SlsPrice]-[RtnPrice]-[SlsDiscnt]+[RtnDiscnt]) AS...