filter report

jeudi 30 avril 2015

I have a report filter that filters the reports by month and year:

Code:


        DoCmd.OpenReport "AttWholeCity", acPreview, , " Month = '" & txtCourseDateMonth & "' AND Year = '" & txtCourseDateYear & "'"

I want the code to also show these two columns where there are null/blank values aswell, for example if I filter by apr 2015 i want the report to show these columns as well as blank columns is this possible
filter report

0 commentaires:

Enregistrer un commentaire

Labels