Search results

Perfect!!! Thank you so much!

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...