I have a database and I need to know how to apply this filter:
How many books published by Bantam were published between 1995 and 2000 inclusive?
I have tried
Author Last Name
"Bantam"
Published Year
Between [1995] And [2000]
And this didn't work.
Also how would I do these:
How many authors won a Macavity award for Best First Novel (nominations don't count)?
How many books published by Bantam, cost more than $15, are over 300 pages long, and have won or have been nominated for any award?
How many books published by Bantam were published between 1995 and 2000 inclusive?
I have tried
Author Last Name
"Bantam"
Published Year
Between [1995] And [2000]
And this didn't work.
Also how would I do these:
How many authors won a Macavity award for Best First Novel (nominations don't count)?
How many books published by Bantam, cost more than $15, are over 300 pages long, and have won or have been nominated for any award?
Last edited: