Ok Got an Interesting one

i used this

INSERT INTO tblout

SELECT *

FROM tblMain

WHERE (tblMain.Depart_Time = Format (Time(), "hh:mm"));

which works to a semi-fashion,

what this seems to do is it selects the previous record...

so if i create 2 seperate queries

CREATE TABLE tblIN

AS

SELECT * FROM tblmain WHERE [DEPART TIME] IS NULL

CREATE TABLE tblIN

AS

SELECT * FROM tblout WHERE [DEPART TIME] IS NOT NULL

should that be...

Hi Lowell

thanks for your advise and it does make sense however

CREATE TABLE tblIN

AS

SELECT * FROM tblmain WHERE [DEPART TIME] IS NULL

GO

SELECT * FROM tblout WHERE [DEPART TIME] IS NOT...

the depart time is generated when the visitor clicks the Out button on the access form (taken from the computers time)

I am using Microsoft Access 2010, with the SQL view on Queries