Printable View
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?
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.
Thanks a lot....
No worries....
:p :p :p :p :p
hahahahaha!
err... i still not sure how to write out the sql statment.... do i join the table to itself b4 tranfering the info?
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.
can you post your code so I can see how you are doing time
then I can help
Erm... nvm... I just got fired for coming into forums... what a dumb company....
Thanks anyway...
What company was it?
Scumbags.
Quote:
Originally posted by Bazzlad
What company was it?
Scumbags.
A company in singapore called Rohr Aero-Services Asia...
I'd boycott them, but I've never heard of the ****ers!