Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: FireGeek21
  • Content: Threads
  • Order by date
  1. FireGeek21

    Add decimal to number string

    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)
  2. FireGeek21

    Max 2 Dates by Employee

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

    Return the Top 2 Records of a Group

    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)
  4. FireGeek21

    Decimal Number

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

    IF Statement

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

    YTD Average by Week

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

    Remove Special Characters Except Spaces

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

    Suppress Groups of Data and Keep Groups of Issues Only

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

    SQL Expression for last 6 months

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

    Multi-Part Identifier Could Not Be bound

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

    Return data after vlookup and condition - macro?

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

    CSS - Horizontal Menu - Can't hover past first item in menu list

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

    Format SSN Input Box

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

    Display mySQL Data Across and then Down

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

    Display Data from mySQL Across and then Down

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

    Change data with an import

    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)
  17. FireGeek21

    Retrieve specific data from mysql based on HTML value

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

    How to check if a specific element is in an array - issue

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

    Item Not Found in Collection

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

    Way to show if someone waived a medical plan

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

Part and Inventory Search

Back
Top