Report Date Criteria

[Forbes]

Hello Everyone, I'm almost finished with a project I and some of you have been working on, I am at a crossroads with a Query criteria. My report prints showing something like this:



Condition-------Number of Conditions--------Conditioned Employee
(Simple List)----(count criteria)--------------(concatrelated based on employee name)(also separated by which department added the record.)

I have a "Timestamp" in the Query as well "Where" Year([timestamp])=Year(Now()) and Month([timestamp])=Month(Now())

The goal here is to only preview the records for that month based off time stamp however, when I run the report it now disregards my "which department added the record" and displays all fields with no thought to date? Can anyone explain why adding this Criteria made the report ignore all of them, also how to correct this problem.

3 Departments = 3 separate reports

I can accept either the ability to specify dates or have the program run reports for the current month.

[pbaldy]

It would help to see the SQL of the query. At a guess, you've got an OR in there that makes it look at one criteria OR the other. I only see a person criteria in the version I've got.

[Bulzie]

Can you give an example of the data in the query.

[Forbes]

Thank you Paul, you were correct after opening the Query in SQL I changed the OR to AND, the report ran perfectly. You're a life saver haha!

[pbaldy]

Happy to help!

[Forbes]

https://www.accessforums.net/showthread.php?t=64973

Are you familiar with ConcatRelated() adding conditions to the code? if you needed any more info that provided please let me know