Search results

I have a query that pulls data for the current month and the last two months. It had been working fine until 2015. The problem is that it's looking for the last two months but for 2015. How do I edit my formula to pick up the two months and for it to know it's a different year?? TIA CMSPM2...

Some additional information I just realized. Text59 is based on formula =DateAdd("m",-2,[Forms]![Main Menu]![EndDate]). When I deleted my Dlookup formula and replace it with =[Text59] to see what the value in that field is I get 10/31/2014 although the Month field value is October 2014 in the table.

Hi, I have a table named z_ResltsSampleCountMonthly. In that table I have fields SampleSize, Month and LOB. I have a report that I need to use a Dlookup in order to pull the SampleSize by LOB into my report. However, my report has three columns that change based on the start and end dates...

Thank you! I used this and it worked: Between DateAdd("m",-2,([Forms]![Main Menu]![StartDate])) And [Forms]![Main Menu]![EndDate]

They enter the month day and year in the main menu form. They can enter any dates in 2013 through 12/31/14 and get the data for the month they entered plus the previous two months. At the end of this month they should be able to enter 1/1/15-1/31/15 data and get January 2015, Nov 2014 and Dec...

Hi, I have a query that the user puts in the start and end date for the month they want the report on the main menu form. The query then pulls data for the month they entered plus the two prior months so they see a trend. I have the following funtion in my query for the date: Between...

Great! That worked. I used =DateAdd("m",-2,[Forms]![Main Menu]![EndDate]) to pull two months prior and =DateAdd("m",-1,[Forms]![Main Menu]![EndDate]) to pull one month prior and =Format([Forms]![Main Menu]![EndDate],"mmmm yyyy") for current month if anyone is interested.

Hi, I have fields on the main menu where folks put in a start and end date prior to running a report. I'm doing a monthly report that pulls current month, and two prior months of data. For example, the user selects a date range of 10/1/14 to 10/31/14 the report will show August, September and...

I have distributed my front end on the shared drive for users to copy to their desktops. In one form I have a formula in the query that show's the word 'Gap' if any of the 15 questions on the form is equal to 'fail'. It runs on current when the user is in a record it shows the word 'Gap' at...

When I set up lookup fields that point to a table do I save those tables in the back end with the main tables or is it okay to have in in the front end and not the back end? Users will need to make udpates to the tables for instance an employee table they would need to add employee names. What...

I did but I get Run-time error '2448: You can't assign a value to this object.

I have some combo buttons in the form header that people can select to filter data in the subform by selecting an option the clicking a button that has code to filter the data. I have another button with the below code that clears all the filtered controls but it's not working all of a sudden...

Thanks everyone! I ended up with:

DIAZ, MARY GOMEZ, LENNY PARKS, LEE Are some examples I need converted.

Hi, I have a table with data that is imported from another application. The employee name is showing up as LName, FName. What function can I use to make these FName LName with no comma? I know I may have to do a two step to separate the two then concatanate but not sure how to do it. Thanks...

Thanks for taking a look at it but that does not seem to work either. I'm getting a Data type mismatch in criteria expression error.

I'm getting the attached error when I change it to WHERE instead of HAVING.

I need the DateValue because when I select the date range for exampel 6/22/14 - 6/30/14 none of my 6/30/14 items show up I'm guessing because the time is later in the day. I use the DateValue to strip the time.

Hi, How do I use the DateValue function with a query that pulls data between dates? Here is my code below. I'm getting an error that my expression is too complex or incorrect. SELECT IIf([tblAUCodes].[BusinessLine] Like '*CMES*',"CMES",IIf([tblAUCodes].[BusinessLine] Like...

Can anyone help?