I need to make a query that will show the past 6 months for each month. So now for an example, if it was February I need to create a SLA report for February, but I need to generate trend graph for the past 6 months to include in the report. But it just continues to show months that are not for the past 6 months.
SQL VIEW
DESIGN VIEW
SQL VIEW
SELECT Vulnerabilities.[Host IP], Vulnerabilities.CVSS, Vulnerabilities.[Risk Level], Vulnerabilities.Vulnerability, Vulnerabilities.[Scan Date]FROM VulnerabilitiesWHERE (((Vulnerabilities.[Risk Level])="Serious" Or (Vulnerabilities.[Risk Level])="High" Or (Vulnerabilities.[Risk Level])="Medium") AND ((Vulnerabilities.[Scan Date]) Between #8/1/2020# And #1/31/2020#));
DESIGN VIEW