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

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

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?

"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

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

Thank you very much Marc

check back soon please