print report with date filter

[Jen0dorf]

Hi

yet another question -thanks people

have a table with a list of books, in that table is a date field that represents the date the book is due back

I created a report and a button to call the report to list all the books this works fine.

I then tried to find where I add filter criteria to only print the books due in the current month taken from the system.

Two issues

1, Can't see where to put the criteria

2. What is the correct format for the criteria - research gave me



=month(date())



But 'm not sure

thanks

Ian

[ranman256]

almost there....
In a blank field in the query
month([DueDate])

In the criteria line under this:
put [Enter Month]
then you can run it for the 1 month.

or
put forms!frmRpt!cboMonth
to use a form instead of user enter parameter

[Jen0dorf]

Hi

I have totaly confused myself which is not difficult I know!!!

I Used the report wizard to create a report based on a table and I've got it looking just as I wanted!!!

I then went to my opening form and in design mode added a button,

right click on the button and selected "build event"

Selected open report, saved it and then pressed the button

Hey presto report displays perfectly.

I now want to filter the results so that in a date field ie 12/11/2015 only the current month is displayed ie if it is now july only month 7 is shown and in august only month 8 is listed.

In the open report dialog box I have options to add a filter name or Where Condition =

I am confused as to which to use.


I have scoured the web and keep finding different bits of code ie

WHERE Format(RenewalMonth,"yyyymm")=Format(Date(),"yyyym m");

I've tried the suggestion in this posting and I'm sure it's right it's just I'm missing something out thats vital

I'm begining to even doubt I'm creating the report in the correct way

Can some nice person tell me if my method is wrong?

thanks

Ian

[Jen0dorf]

Hi

solved

Month([RenewalMonth])=Month(Now())

thanks all

Ian