MS Access database engine does not recognize..... as valid name or - Microsoft Community

error #3070 ms access database engine not recognize " valid name or expression

i using form enter criteria query using select , crosstab query generate report.  parameters defined in queries used, date formats consistent throughout.  when enter date using single digit month such 07/01/2016 start date, , 07/31/16 end date, queries , report run no problem.....  resulting data correct.  if use date 2 digit month such 11/01/2016 11/30/2016, error message , stops.  it months of 10, 11, , 12 query not read.  

parameters [forms]![typerptcriteria]![start] datetime, [forms]![typerptcriteria]![end] datetime;
select [cats stats].id, [cats stats].[type of cancer], gender1_crosstab.[family member], [cats stats].age, [cats stats].gender, gender1_crosstab.female, gender1_crosstab.male, [cats stats].ethnicity, [cats stats].[zip code], [cats stats].[referral date], [cats stats].[referral source], [cats stats].[start date], [cats stats].[end date], [cats stats].[sessions offered], [cats stats].referral, [cats stats].[pre score], [cats stats].[post score], year([start date]) [year]
[cats stats] left join gender1_crosstab on ([cats stats].[family member] = gender1_crosstab.[family member]) , ([cats stats].[type of cancer] = gender1_crosstab.[type of cancer])
((([cats stats].[start date]) between [forms]![typerptcriteria]![start] , [forms]![typerptcriteria]![end])) or ((([forms]![typerptcriteria]![start]) null) , (([forms]![typerptcriteria]![end]) null));

any possible solutions appreciated!

ronmnj

wonder if problems due missing columns in crosstab due data missing in selected date range.  using crosstab query's column headings property specify columns appear in output?

Office / Access / Other/unknown / Office 2010