Filter data from a query

[Alex]

Hello all
I have a project like this:
Like counting people go in to a room with 2 sensors. I would like to
monitoring products go in and out the warehouse. Because Sensor 1 and 2 are
so sensitive, one the product ID can be recorded for several time at one
sensor when it move in.
I would like to get only one time value for each time the product come in in
order to report its ingressing or esgressing

ProductID Sensor Date Time
I1234H 1 09/19/08 11:02:06.122
K1353Q 1 09/19/08 11:02:06.222
K1353Q 1 09/19/08 11:02:06.422
I1234H 1 09/19/08 11:02:06.526
I1234H 2 09/19/08 11:02:07.122
K1353Q 2 09/19/08 11:02:07.321
I1234H 1 09/19/08 12:02:06.122
I1234H 1 09/19/08 12:02:06.126
K1353Q 2 09/19/08 12:02:07.321

Expected data:

ProductID Sensor Date Time
I1234H 1 09/19/08 11:02:06.122
K1353Q 1 09/19/08 11:02:06.222
I1234H 2 09/19/08 11:02:07.122
K1353Q 2 09/19/08 11:02:07.321
I1234H 1 09/19/08 12:02:06.122
K1353Q 2 09/19/08 12:02:07.321

I try to apply the previous post "difference between values of multiple
records" but it not work.Do you have any idea?

 

[Peter]

Deat customer Services,
For some reason I have received a
whole lot of queries for you guys.How do
I forward them on without sitting here all day.
Regards
Peter Littlejohn

 

[Tom Wickerath]

Peter,

What are you asking, and to whom do you think you addressed your inquiry?
This is a newsgroup intended for Q&A related to Microsoft Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Wickerath]

Hi Alex,

First, the words "Date" and "Time" are not good choices for anything that
you assign a name to within Access, since these are considered reserved
words. You should avoid using any reserved words for things that you assign a
name to:

Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html


As far as I know, the Date/Time data type in Access/JET only supports time
resolution to the nearest second. The time values you are showing seem to be
to the nearest thousandth of a second. For example, on the first record, you
show 11:02:06.122. What is the .122?


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________