var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query quandry...
I am trying to create a SQL query that will look up a date range. I get a runtime error #13 - Type mismatch when I try... Any help on what I might be missing would be appreciated.
Where represents the SQL lookup.
Where = Where & " AND [PC_REQ_REQUEST_DT]BETWEEN '" + _ Me![fld_Reqst_Start_DT] + "AND" + Me![fld_Reqst_End_DT] + "'"
you're missing some spaces (e.g. around the AND) but most of all, you need to use the octothorp (hash or pound sign) to delimit access dates
" ... BETWEEN #" + Me![fld_Reqst_Start_DT]
+ "# AND #" + Me![fld_Reqst_End_DT] + "#"