How do I...

[Guest]

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

 

[Rick B]

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


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

 

[Guest]

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?

 

[Marc]

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

 

[PC Datasheet]

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
(e-mail address removed)
www.pcdatasheet.com

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