Search results

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.

I've attached a screenshot of my Table. What I need to do is total the Quantity field for each day (for example on 10/24/2013 Location 1 used 113 units and Location 2 used 3.5 units for a total of 116.5). Then when I have a total for each day, I need to sort that total, so that for example I can...

I'm trying to create a report for my organization that sums the amount of material used by date. For example, I have five separate locations in my organization that all consume the same material. It gets reported separately by location. I need to know the total material consumed each day. Then I...

Is it possible to change the text color in the same maner? For instance I tried changing "BackColor" to "TextColor" but no luck. Thanks.

OK, thanks much guys, I think I got it. Just out of curiosity, it seems the formatting (colored background) only shows up in Print Preview but not in Report View. Any idea why?

Got it. Thanks. Since there are more than 1 employee that need to be selected (with a different color background) does each one need his/her own If/Then/Else Statement, or can they be combined? For example: If Me.EmployeeName = "Doe, John R-12345" or "Smith, Susie L-54321" etc.