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 Chriss Miller 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: *

  1. md092686

    Grid Layout Mode

    I have a web form that I am designing. How do you turn on the grid dots so I can line up the labels and textboxes. In Visual Studio 2005 in Web Design I can't find where you turn on the grid dots to show with SHOW GRID with Check mark as the book shows under options.
  2. md092686

    Visual Studio 2005 Question

    I do not know if there is a forum on use of Visual Studio 2005, but I have a questions about turning on the Grid dots on a web form. Anybody out there know how to turn this on?
  3. md092686

    Access Problem

    I have a Store Number that is in a table 001 in file1 and I have Store Number as 1 in another file2. I want to change all of the store Numbers in File2 to 001 until you reach Store 10 by placing two zero's to the left of 1. Now when the number changes to 10 I need for the number to have only 1...
  4. md092686

    Access Date Problem

    I have a field with dates that are Text 10012007. I want to place a slash between the date as: 10/01/2007. Can an update procedure do this in a query?
  5. md092686

    Date Subtraction

    I have a column field which is formatted with Date/Time called LVPROGDATE and another column field formatted with Date/Time called Date To in ACCESS. I want to subtract the LVPROGDATE - DATE To to get the Number of Days of Longevity whihc will be Column 3. Is there a quick way to do this with...
  6. md092686

    ACCESS Date Conversion

    Skip, I appreciate you helping me. I got it to work fine! Thanks md092686
  7. md092686

    ACCESS Date Conversion

    Skip, I knew that I guess I am not thinking well this Monday afternoon. Yes, you can never do arithmetic with a string. Anyhow, I got it to work. Thanks md092686
  8. md092686

    ACCESS Date Conversion

    The date is formatted as a Number in Access from the Mainframe. I have placed your Expression in the criteria part as: DateSerial(mid([ABCDate],1,4) ,mid([ABCDate],5,2),mid([ABCDate],7,2)) Yet, when this is run, i get no results. Don't you need the "/" between & somehow?
  9. md092686

    ACCESS Date Conversion

    I have a field column with dates in this format 20070506. I need to convert this date to: 5/6/2007 with slashes but have the date appear as mm/dd/yyyy. Is there a quick conversion function to do this? Thanks md092686
  10. md092686

    SQL Problem

    Boris, I believe I can get my results with your query once I learn how to develop my percentages from your TotalEMp and TotalEMPL. Is it possible to do a calculation with the TotalEMP and TotalEmpl? Like TotalEMP/TotalEmpl AS Percentage Race. How would I word this in the coding? When I Try...
  11. md092686

    SQL Problem

    Boris, We are very close. I need for a total to occur on Whites by HORGCD, Blacks By HORGCD, HISPANIC BY HORGCD, American Indian by HORGCD, ASIAN by HORGCD, and so on. So I need a column to appear with for example on 0010 HORGCD there should be 6 Whites which are composed of 3 White Females...
  12. md092686

    SQL Problem

    Willie, Yes, I need to know how many males and females of each race that I have by DHORGCD. I have got the Query to work, but I do not know how to place the SEX in there. Look at this query and see what I need to do. SELECT Tbl1.HORGCD, COUNT(*) AS TotalEmp, Tbl1.RACE...
  13. md092686

    SQL Problem

    Boris, When I run the view I get an error message, [male and/or Female] is an invalid field name.
  14. md092686

    SQL Problem

    Boris, The query you made from the Tables is: HORGCD TotalEmp RACE SEX TotalEmp1 0010 1 Black Male 7 0010 3 White Male 7 0010 3 White Female 7 The TotalEmpl you have is 7. This is correct But I need to take...
  15. md092686

    SQL Problem

    Boris, This Coding gives the following: HORGCD TotalEmp long-name Sex TotalEmp1 0010 1 Black/Afr. Amer. M 7 0010 3 White F 7 0010 3 White M 7 0020 1 Black/Afr. Amer. M 12 0020 9 White F 12 I need for TotalEmp to...
  16. md092686

    SQL Problem

    I am trying to compute Total Employees that are White, Black, Indian, etc by an ORG Code. The ORG Code for Admin would be 0010. I have attached an example of what I am trying to do. I have 1 Black Male and 3 White Males and 3 White Females. I need a Total Field to give me under Total...
  17. md092686

    Finding Records that APpear in One Table and Not Another

    No, This is real work.
  18. md092686

    Finding Records that APpear in One Table and Not Another

    I have two tables called RetailSales0607A and RetailSales0607B. Both tables contain the same field names with data. The field names are: StoreNumber, StateCode, and BottleSales. RetailSales0607A contains 91,000 records. RetailSales0607B contains an update of 92,000 records. I need to select...

Part and Inventory Search

Back
Top