G
Guest
I have a form that has a start date field and an end date field. This is
linked to a report that runs on a query for start date and end date. I have
made the query pick up the dates on a between(form1!start date)and(form1!end
date) for some reason if I put the date in as 01/01/06 and end 15/01/06 I
still get all the 2005 information. What can I be doing wrong. Here is the
query code
SELECT DISTINCTROW [STATS CAMP].EMPLOYEE, [STATS CAMP].NAME, Format$([STATS
CAMP].DATE,'Short Date') AS [DATE By Day], [STATS CAMP].DIVISION, Sum([STATS
CAMP].[Count Of STATS]) AS [Sum Of Count Of STATS]
FROM [STATS CAMP]
GROUP BY [STATS CAMP].EMPLOYEE, [STATS CAMP].NAME, Format$([STATS
CAMP].DATE,'Short Date'), [STATS CAMP].DIVISION
HAVING (((Format$([STATS CAMP].[DATE],'Short Date')) Between ([Forms]![CAMP
DAY COUNT]![START DATE]) And ([Forms]![CAMP DAY COUNT]![END DATE])))
ORDER BY Format$([STATS CAMP].DATE,'Short Date') DESC;
Thanks my form has the fields as short dates also.
linked to a report that runs on a query for start date and end date. I have
made the query pick up the dates on a between(form1!start date)and(form1!end
date) for some reason if I put the date in as 01/01/06 and end 15/01/06 I
still get all the 2005 information. What can I be doing wrong. Here is the
query code
SELECT DISTINCTROW [STATS CAMP].EMPLOYEE, [STATS CAMP].NAME, Format$([STATS
CAMP].DATE,'Short Date') AS [DATE By Day], [STATS CAMP].DIVISION, Sum([STATS
CAMP].[Count Of STATS]) AS [Sum Of Count Of STATS]
FROM [STATS CAMP]
GROUP BY [STATS CAMP].EMPLOYEE, [STATS CAMP].NAME, Format$([STATS
CAMP].DATE,'Short Date'), [STATS CAMP].DIVISION
HAVING (((Format$([STATS CAMP].[DATE],'Short Date')) Between ([Forms]![CAMP
DAY COUNT]![START DATE]) And ([Forms]![CAMP DAY COUNT]![END DATE])))
ORDER BY Format$([STATS CAMP].DATE,'Short Date') DESC;
Thanks my form has the fields as short dates also.