Recent content by md092686

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.

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?

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

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?

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

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

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

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?

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

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

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

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

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

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

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