Help with a MS Access report.

[Dave0291]

Hi there,

I need help with a report I am trying to build for work. I have a simple for called "AuditTotal" with two Date/Time fields "start_Date" and "end_Date" and an open report button. My report has a query called "AuditPTETotal" as it's record source.

Once I fill out the dates and press the open report button, I would like the report to show up and display the data retrieved by my query for the given time range specified in my form.

I've tried running the report and query with using the dates and that is working fine so I know it is not the report or the query. But when I try to run it with a date range, I get this error message...

"The Microsoft Access database engine does not recognize " as a valid field name or expression"

I'm not sure what that means or how to fix it... Any help would be greatly appreciated.

Here is my query:

PARAMETERS [Forms]![AuditTotal]![start_Date] DateTime, [Forms]![AuditTotal]![end_Date] DateTime;
TRANSFORM Sum(ScrapCollection.PTEtotal) AS SumOfPTEtotal
SELECT ScrapCollection.regNum, ScrapCollection.Date
FROM ScrapCollection INNER JOIN (ScrapTireType INNER JOIN ScrapCollectionTireType ON (ScrapTireType.scrapTireTypeID = ScrapCollectionTireType.scrapTireTypeID) AND (ScrapTireType.scrapTireTypeID = ScrapCollectionTireType.scrapTireTypeID)) ON ScrapCollection.scrapCollectionID = ScrapCollectionTireType.scrapCollectionID
WHERE (((ScrapCollection.Date)>=[Forms]![AuditTotal]![start_Date] And (ScrapCollection.Date)<=[Forms]![AuditTotal]![end_Date]))
GROUP BY ScrapCollection.regNum, ScrapCollection.Date
PIVOT ScrapTireType.description;
 

[Dave0291]

I found a solution! I was using a Date/Time format on my controls. I think it was messing up with the actual format of my parameters. Instead I used a regular text box and set an input mask to it. It worked.