Getting closer! It is pulling in June, July and August just fine but it is also pulling in September and I want to exclude September for my October report. When I roll into November, I will only want July, August and September. Thoughts?
Using this, I was pulling in July thru October invoices so I slightly changed your query to below and that included June but I am still pulling in Sept and Oct transactions. I want to pull in only June, July and August when running the report in October. In November, I will want only July...
I am getting a syntax error on this - says I did not enter the keyword AND in the between...and operator. Says the correct syntax is a follows: express [Not] Between value 1 and value 2. Not sure what is wrong. Here is my query:
BETWEEN DateSerial(Year(Date()), Month(Date())-4, 1) AND...
I am trying to figure out how to build a query that will pull data from three consecutive months in the past.
I am working with a table that contains open invoices from multiple customers. This table contains a "ShipDate" column with a date format of 01/01/2022.
I want to setup the query...