Merging records..

**Georgieboyz** · Aug 28th, 2003, 03:27 AM

Hi there... i'm not sure how to do this...

I have a table which has

Emp_No,Emp_Job,TimeIN,TimeOut,DateIn,DateOut,Emp_SnE

as the fields. The form has two buttons, "Time In" & "Time Out", so when one is clicked, the other fields become null.

What i need to do now is create a new form with a button. when the button is clicked it has to search the old table for matching records and insert the merged records in a new table. This new table also has a new column called total time.

can anyone help?

**Bazzlad** · Aug 28th, 2003, 03:47 AM

This site will teach you how to do it,
and it only takes about 30 minutes....
http://www.w3schools.com/sql/sql_intro.asp
Enjoy.

**Georgieboyz** · Aug 28th, 2003, 03:55 AM

Thanks a lot....

**Bazzlad** · Aug 28th, 2003, 03:57 AM

No worries....

hahahahaha!

**Georgieboyz** · Aug 28th, 2003, 10:51 PM

err... i still not sure how to write out the sql statment.... do i join the table to itself b4 tranfering the info?

**Bazzlad** · Aug 29th, 2003, 03:34 AM

If you're wondering WHERE you write the SQL, you have to go into QUERY, NEW QUERY, then in the top right there's a little box which says SQL. Click it.

**adocwra** · Aug 29th, 2003, 09:59 AM

can you post your code so I can see how you are doing time
then I can help

**Georgieboyz** · Aug 29th, 2003, 10:48 AM

Erm... nvm... I just got fired for coming into forums... what a dumb company....

Thanks anyway...

**Bazzlad** · Sep 2nd, 2003, 04:41 AM

What company was it?
Scumbags.

**Georgieboyz** · Sep 2nd, 2003, 11:45 PM

Originally posted by Bazzlad
What company was it?
Scumbags.

A company in singapore called Rohr Aero-Services Asia...

**Bazzlad** · Sep 3rd, 2003, 03:16 AM

I'd boycott them, but I've never heard of the ****ers!

Thread: Merging records..

Thread Tools

Display

Merging records..

Posting Permissions