Search results for query: *

New to JS and appreciate the help on this forum! Have numbers as stings whereby the last 2 numbers were understood as the decimal. This needs to change. Would like help on how to do this. String = 123456 Need = 1234.56 FireGeek (currently using Crystal Reports XI with Lawson 9.01)

I need the max 2 check dates for each employee. I was using a temp table for the most recent check date but now I need the check just before it but keep getting ALL checks before the max check. Here is my code: SELECT PAY.COMPANY as tCO, PAY.EMPLOYEE as tEE, MAX(PAY.CHECK_DATE) as tCHKDT...

I need to return the top 2 historical records of a group. Group is by Employee. Each employee may have a different number of records. Need the most recent 2 by date. Thoughts??? FireGeek (currently using Crystal Reports XI with Lawson 9.01)

Hi, I need a formula that will force a number field not to round. It seems because of settings in File -> Options -> Fields tab -> Number -> Number tab my formula field is rounding to 2 decimal places. I need the full 4 decimal number to show. Cavaet is that this ends up displaying in a TEXT...

HI, Beginner here... I may have some syntax off a bit. Looking for some help here. I am adding a colored circle depending on the "level" in a database. The code before this connects to the database. Everything worked fine until I added the "IF" statement for the colored circles. Where...

I need to show a YTD average by week. I can get a weekly average but I can't seem to average year to date and show what that YTD average looked like each week. Average is amount of time it takes to get a task done. For example: Week 1 average = 45 YTD average at week 1 should be 45 Week 2...

HI! I need to remove all special characters from a field except spaces. I found the following code here on Tek-Tips however it is also removing spaces too. Now my an address such as 1234 O'Mally Street appears 1234OMallyStreet and I need 1234 OMally Street. I know the ascii character for...

I am trying to find a group set of data that have problems and suppress group sets that are not a problem. In the sample dadata below, group sets A & B are issues because the second column is not the same all the way through. Group sets C & D are ok. How can I identify and keep group sets like...

I am using a SQL Expression to pull in some data. I need a value if it occurs in the last 6 months from today. This file will run weekly so the last 6 months is a moving date range. In the WHERE clause, I have been able to use a date range when the start/stop is known such as the following...

I have a SQL Expression (not a command) to bring in a field and I am getting an error "Multi-Part Identifier Could Not Be Bound". Any thoughts? Here is my SQL Expression: (SELECT PAPOSITION.DEPARTMENT FROM PROD.dbo.PAPOSITION WHERE PROD.dbo.PAPPOSITION.EFFECT_DATE <...

I have 2 Excel files and I need to move some data from one file to the other based on a value and other conditions. I have done vlookups and if formulas before but I believe this will entail more - maybe a macro. In my main file, I have a column with values I need to match with the first...

I am updating the menus on my website so they display as menu categories with list items that drop down and are viewable when you hover over the menu item. One of my webpages works but 2 others do not. Before I continue with my updates, I would like to identify the issue. Unfortunately, I...

I have an input box I would like to format. If the user enters as all numbers it shoud format as xxx-xx-xxxx. If a user enters as xxx-xx-xxxx then the formating should remain. I have the following code: Code for the input box: + '<td class="plaintablecell" nowrap><span id="ficaspan"><input...

Hi, On our fire department website we would like to add a page of pictures of our personnel. I am against adding names of our personnel directly into the html code so I have a mySQL database with their name, position, email address, and image file. I am using php to pull the data out and...

Hi, On our fire department website we would like to add a page of pictures of our personnel. I am against adding names of our personnel directly into the html code so I have a mySQL database with their name, position, email address, and image file. I am using php to pull the data out and...

Looking to find out if it is possible to change existing data in an Access table with data from an import file (Excel) based on a key field. Ideas on how to do this??? Thanks!! FireGeek (currently using Crystal Reports XI with Lawson 9.01)

I am new to php and am working on a web page of employee pictures. I would like to protect our employee information so would like to retrieve data based on a specific number from a mysql database. I would like to return only a single field (Position) based on a value in HTML code. Here is...

I need to find out if an array parent.EligPlans[i][2] has a specific plan in it. If so, then I need to assign it to a variable for later use after a "for" loop. There are some elements in this array I don't want to deal with (apply a custom message in this case) but there are 7 specific...

I am getting "Item Not Found in Collection" in this FORM_LOAD function. Can anyone see what the issue is? I've been looking at this far too long to see the issue. Dim sql As String Dim ItemName As String Dim db As DAO.Database Dim rs As Recordset Dim x As Integer...

Well, thanks to health care reform, I have a new challenge on my hands! I have been looking at this on and off for a few days now and can't seem to resolve this. Hoping someone can guide me in the right direction. Basically, we need to list when someone has not elected a medical plan -...