Solved Graphs based on Query

[StuartG]

Hi all,
I have created some Graphs based on a query but the results are not reporting my requirements.

Issue
Below is the query
I only wanted it to include all orders apart from orders not yet booked.

Graph output

No records showing


Desired Effect.
I would like the graph to show only records that are created within 2021 QTRs, but needs to reset when the next year happens.
Using the criteria outlined above.

Can anyone point me in the right direction where I could be going wrong?

Thanks
Stuart

 

[theDBguy]

Can you post a sample db?

 

[Minty]

I think you would want

Year([Opened Date] = Year(Date())

in the criteria not

[Opened Date] = Year(Date())

Assuming [Opened Date] is a full date field.

 

[StuartG]

I think you would want

Year([Opened Date] = Year(Date())

in the criteria not

[Opened Date] = Year(Date())

Assuming [Opened Date] is a full date field.

Hi Minty, thanks for the reply.
I did that on the order booked column as i learnt that users want to see it by the date the order was booked.

I copied as you had done.

 

[arnelgp]

you Create a New Column on your Query:

Field: Expr1: Year([Order Booked])
Show: (no tick)
Criteria: Year(Date())

 

[StuartG]

you Create a New Column on your Query:

Field: Expr1: Year([Order Booked])
Show: (no tick)
Criteria: Year(Date())

Thanks Arnel that seems to have cracked it.
I guess that will show each QTR through this year and then revert to QTR 1 next year?

 

[arnelgp]

I guess that will show each QTR through this year and then revert to QTR 1 next year?

it should, since you are using Date() function (current date).
unless you delayed or advanced your computer date?