CODEWITHSUNDEEP
ms-accessreport
barry17
barry17

Reputation: 153

Access Reporting displaying data in report?

I'm making a simple inventory report for the user. What I'm allowing the user to do is, enter a FROM and TO Date and only filter by those dates for the report. This is a VB6 information, so I pass the value to an empty form with a filed FROM and then use that in the report. In the report, I'm trying to display the Month and Year, ex November 2015 if the report request is for November. How would I go about doing that?

Upvotes: 0

Views: 31

Answers (1)

user2204315
user2204315

Reputation:

I would create an unbound field on the form to display the first of the month following the date inputted by the user, using standard date functions DatePart and DateSerial. So if the user inputs a date in November the unbound field displays 01 December 2015 and your report is based on that date.

Upvotes: 1

Related Questions