If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I...
I would like to use access to make an hours projection sheet/record of employee/employer performance.
To do this I want the ability to type in the employee's number and the rest of their pertinent information will be filled in. I would also like to keep a running total of employee hours that will reset to 0 upon reaching its threshold and award 'bonus' points Is there any way to do a mass separation of first and last names? Is it a good idea to arrange an employee database with first and last names in separate columns? Thank you 5 more questions shortly |
#2
|
|||
|
|||
How do I...
I would store the names in two fields. In some screens/reports you may want
them printed as Last,First but in other places you may wnat them First Last. Storing them separately gives you this ability. Rick B "venusasaboy" wrote in message ... I would like to use access to make an hours projection sheet/record of employee/employer performance. To do this I want the ability to type in the employee's number and the rest of their pertinent information will be filled in. I would also like to keep a running total of employee hours that will reset to 0 upon reaching its threshold and award 'bonus' points Is there any way to do a mass separation of first and last names? Is it a good idea to arrange an employee database with first and last names in separate columns? Thank you 5 more questions shortly |
#3
|
|||
|
|||
How do I...
Okay, so I can start typing new entries with separate first and last names.
Currently, my other 3570 entries are in the format of "Smith, John". Can Access create two columns (first name/last name) out of the one [whole] name column? I have gotten to the point that I can select a name from a drop down list. Can I have one specific field save itself to the original database? |
#4
|
|||
|
|||
How do I...
"venusasaboy" wrote in message
... Okay, so I can start typing new entries with separate first and last names. Currently, my other 3570 entries are in the format of "Smith, John". Can Access create two columns (first name/last name) out of the one [whole] name column? I have gotten to the point that I can select a name from a drop down list. Can I have one specific field save itself to the original database? Big if first - this is a standard format. Careful if it is not. Open a query Add the table with the source data Click and drop name field Go to a new column click on the wand at the top. In the box type in Surname: Left([namefield], instr(1,[namefield],",") - 1) 'take all letters left of comma New column: In the box type in Firstname: Right([namefield], Len([namefield])-instr(1,[namefield],",") ) 'take all letters left of comma Test. If you're happy with the results that the majority of names are correctly converted then Change the query to an update query for the table the split fields are to go into. In the new columns enter the fields the new information is to go into. And run. Go back and edit the minority of records that are not transformed correctly HTH Marc |
#5
|
|||
|
|||
How do I...
If you would like some help with this, contact me at the email address below.
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "venusasaboy" wrote in message ... I would like to use access to make an hours projection sheet/record of employee/employer performance. To do this I want the ability to type in the employee's number and the rest of their pertinent information will be filled in. I would also like to keep a running total of employee hours that will reset to 0 upon reaching its threshold and award 'bonus' points Is there any way to do a mass separation of first and last names? Is it a good idea to arrange an employee database with first and last names in separate columns? Thank you 5 more questions shortly |
#6
|
|||
|
|||
How do I...
Thank you very much Marc
check back soon please |
Thread Tools | |
Display Modes | |
|
|