Skip to content
Advertisement

Count of files received in the last 30 days split by each day

I am trying to get a count of the number of files my company has received in the past month split up by each day. The example below shows what I want the output to look like.

The PK for my table is RecNo and the date variable is DateRecd.

Thank you in advance!

Advertisement

Answer

Do you just want aggregation and filtering?

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement