Search results

Hi got it working with: DoCmd.OutputTo acOutputReport, "rptProjectTimesbyDate", acFormatXLS, "S:\xx\xx\rptProjectTimesbyDate.xls" Thanks again :)

Hi Gasman, no the stStartDate is UK date too. First of September. Changed it to this: stReportCriteria = "[Date Worked] Between #" & Format(stStartDate, "mm/dd/yyyy") & "# And #" & Format(stEndDate, "mm/dd/yyyy") & "#" and all is working. Thanks for your help :) Could you point me in the...

Thanks for your replies. I've been staring at this for a while and possibly got muddled up a little. It doesn't throw an error with: stReportCriteria = "[Date Worked] Between #" & stStartDate & "# And #" & stEndDate & "#" but it doesn't generate the report based on the dates given. The...

Hi, I have an issue which I can't resolve so would like some advice. I'd like to generate a report between two dates in the [Date Worked] field passed as criteria to the report. Those dates are from 30th June (what ever year we're in) to today's date. I'd then like to export it to Excel...