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

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

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

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

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

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

Hi, I have a report with four subreports. If the subreports have no data I have a formula to put the word 'none' in the first field as follows: =IIf(IsNull([Question]),"None",[Question]) I do a print preview and the word 'None' shows up and subreport looks good when I view just the...

I used the wizard to create a find duplicates query. I know for a fact that 15 records are duplicates. I'm getting over 300 records. When I dumped the data into Excel and did a pivot table to count the number of records by account number only 15 had a total count of 2. All others only had 1...

Hi, I have the following code Gap: IIf([Q1]=2,"GAP",IIf([Q2]=2,"GAP",IIf([Q3]=2,"GAP",IIf([Q4]=2,"GAP",IIf([Q5]=2,"GAP",IIf([Q6]=2,"GAP",IIf([Q7]=2,"GAP",IIf([Q8]=2,"GAP",IIf([Q9]=2,"GAP",IIf([Q10]=2,"GAP",IIf([Q11]=2,"GAP",IIf([Q12]=2,"GAP",IIf([Q13]=2,"GAP",IIf([Q14]=2,"GAP",""))))))))))))))...

Hi, I have a user that uploads a spreadsheet weekly. I want to assign a unique id to each record that is the current date plus the start and end date for the data they are loading which would be the week prior plus a counter. For example: Data from the week of 5/4-5/10 is loaded on 5/12...

I want to combine six different memo fields into one. I found this code and it works to combine two fields so I edited to add a third and it does not do anything. Comments: [QAComments1] & IIf(IsNull([QAComments2]),"","; " & [QAComments2]) This is my edited code to add a third field...

I have a form that closes when I click to change the view or if I use the record selector to move to the next record. The form closes and when I re-open it the next record is showing. Any ideas what's going on and how to begin troubleshooting? TIA

I've used this parameter back in Access 2.0 where I ask for I put [What location?] as the parameter and users can put 'North' or hit enter to get all locations. I can't figure out what the 'code' is behind this. Any ideas? Thanks.

We have a memo field that folks may add to on different days. Additionally, different users may add notes if the person who started to work on the transaction is out of the office. My manager would like to add a way to include the date and initials of the person that added a new memo...

I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops. I set up a main menu for them to access the various forms, reports, etc. When I first open the...

I have a date in my form that folks fill in when they have completed that record. The date will be blank if they have started the record or have not started at all. If they have started completing the form by selecting pass or fail from the dropdown for each of the 9 questions in the form and...

I have the following code that updates the end date to be the same as the start date after the user tabs out of the start date. Instead of making it the same date, I want it to be six days later. How do I add that? For example, user enters 11/10/13 in the start date. I want the end date to...