Recent content by depawl

Got it. Thanks very much.

jdraw: Yes, I am somewhat familiar with both of those functions, but was stumped by Galaxiom's use of the IIF Month within the DateSerial year, but your reply prompted me to chew on it a bit more, and i think it's beginning to sink in. Thanks.

Many thanks to all, I'm sure they are all workable solutions, but with my (very) limited programming skills, Galaxiom's code is the only one that I have any idea of where to start. Galaxiom: Can you explain the logic behind the iif(Month(date())>3,2,3 portion of your code?

Well this appears to be a bit more challenging than originally anticipated. Since I need the query to return the most recent 3 full fiscal years of data, for example, on March 31, 2015 the query would need to return data from April, 1 2011 to March 31, 2014; whereas on April 1, 2015, the query...

Thanks plog. Just got back to this after doing some other stuff. Tried your suggestion and it works fine.

Thanks all, I will give this a try at work today.

My company's fiscal year begins on April 1st. I need to design a query that pulls data from the most recent 3 full fiscal years. For example, today the query would need to pull data from April 1, 2012 through March 31, 2015. A year from today, the query would need to pull data from April 1, 2013...

Thanks. The data does not contain any dates in the future.

>Date()-365 as suggested by Minty seems to work. Thanks to all.

I need to develop a query to retrieve, for example the previous 1 year of performance data. The query is based on an oracle database table (which I don't have the permissions to change). The date field in the table is in date/time format. So in my query: "Date()" for some reason works ok...

Here's the form with an explanation of what I'm doing: https://support.microsoft.com/en-us/kb/290133

I've developed a form that runs via a macro for a long running query that pops up a message: "Please Wait". The query involves parameters that the user must input. What I'd like to accomplish is to not have the pop-up message appear until after the user inputs the parameters. I think this...

Thank you for your responses, but those tables have been developed by others in my agency and changing them is out of the question. So in a nutshell I need to work with what I have.

OK, I have a query that pulls data from 2 tables. The first table (let’s call it Table A) has employee information (employee name, job title, ID#, etc.). The second table (Table B) has information on training courses that employees have taken. So my query pulls the latest employee information...

Thanks, got it. My problem was I was including too many fields in my aggregate query.