Expression in a query

[Radhika]

I have a table called 'tbl_TEPRecords' with three fields of interest ,
'ID#'(primary field), 'DateOfVisit' and 'VPInsertionDate'. I want to use this
table to create a query that finds the fields where VPInsertionDate on the
second DateOfVisit for each ID# is not equal to the First DateOfVisit. Below
is an example of such a combination:

ID# DateOfVisit VPInsertionDate
111111 01/01/2001
111111 02/01/2001 011/01/2001 (instead of 01/01/2001)

How can I go about doing this?

Thankyou,
Radhika

 

[Brendan Reynolds]

I have a table called 'tbl_TEPRecords' with three fields of interest ,
'ID#'(primary field), 'DateOfVisit' and 'VPInsertionDate'. I want to use
this
table to create a query that finds the fields where VPInsertionDate on the
second DateOfVisit for each ID# is not equal to the First DateOfVisit.
Below
is an example of such a combination:

ID# DateOfVisit VPInsertionDate
111111 01/01/2001
111111 02/01/2001 011/01/2001 (instead of 01/01/2001)

How can I go about doing this?

Thankyou,
Radhika

This should do it I think ...

SELECT tblTest.[id#], Min(tblTest.dateofvisit) AS MinOfdateofvisit,
Min(tblTest.vbpinsertiondate) AS MinOfvbpinsertiondate
FROM tblTest
GROUP BY tblTest.[id#]
HAVING (((Min(tblTest.dateofvisit))<>Min([tblTest].[vbpinsertiondate])));