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
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];
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...