By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Help with a MS Access report.

P: 33
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:

Expand|Select|Wrap|Line Numbers
  1. PARAMETERS [Forms]![AuditTotal]![start_Date] DateTime, [Forms]![AuditTotal]![end_Date] DateTime;
  2. TRANSFORM Sum(ScrapCollection.PTEtotal) AS SumOfPTEtotal
  3. SELECT ScrapCollection.regNum, ScrapCollection.Date
  4. FROM ScrapCollection INNER JOIN (ScrapTireType INNER JOIN ScrapCollectionTireType ON (ScrapTireType.scrapTireTypeID = ScrapCollectionTireType.scrapTireTypeID) AND (ScrapTireType.scrapTireTypeID = ScrapCollectionTireType.scrapTireTypeID)) ON ScrapCollection.scrapCollectionID = ScrapCollectionTireType.scrapCollectionID
  5. WHERE (((ScrapCollection.Date)>=[Forms]![AuditTotal]![start_Date] And (ScrapCollection.Date)<=[Forms]![AuditTotal]![end_Date]))
  6. GROUP BY ScrapCollection.regNum, ScrapCollection.Date
  7. PIVOT ScrapTireType.description;
  8.  
Jun 6 '12 #1

✓ answered by 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.

Share this Question
Share on Google+
1 Reply


P: 33
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.
Jun 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.