'Query to count different fields

I have a table with the following values:

Date of creation
IDNumber
Type of expte (can be "1" or "30")
Author (5 different options)
Sent to print (Date when it was sent)
Critics (5 different values)
Critic Date (Date when the critic was published)

And I want to create a query which, given a period of time (the query should ask for "Date from" and "Date until" and the user can type whatever they want; for instance: from 01/01/2022 to 16/01/2022) it gives the following results:

  • Number of exptes created in that period of time that are Type "1"
  • Number of exptes created in that period of time that are Type "30"
  • Number of exptes created in that period of time that are Type "1" created by Author "A"
  • Number of exptes created in that period of time that are Type "1" created by Author "B"
  • Number of exptes created in that period of time that are Type "1" created by Author "C"
  • Number of exptes created in that period of time that are Type "1" created by Author "D"
  • Number of exptes created in that period of time that are Type "1" created by Author "E"
  • Number of exptes created in that period of time that are Type "30" created by Author "A"
  • Number of exptes created in that period of time that are Type "30" created by Author "B"
  • Number of exptes created in that period of time that are Type "30" created by Author "C"
  • Number of exptes created in that period of time that are Type "30" created by Author "D"
  • Number of exptes created in that period of time that are Type "30" created by Author "E"
  • Number of exptes sent to print in that period of time (but they could have been created in other period of time)
  • Critics received in that period of time which have value "1"
  • Critics received in that period of time which have value "2"
  • Critics received in that period of time which have value "3"
  • Critics received in that period of time which have value "4"
  • Critics received in that period of time which have value "5"

I am very noob in access and the db was created by someone is already retired so I don't know how to do that. Any help is appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source