First entry

  • Thread starter Thread starter Mick
  • Start date Start date
M

Mick

I have at query where I am showing a days production. I
need to pick the first entry, by time, for each machine
for each date.

Fields are
Date
Click to expand...

Any help would be appreciated.

Tahnks
Mick
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Assuming "first entry" means the earliest Time, perhaps this:

SELECT [Date], Min([Time]) As FirstEntry, Machine
FROM tableA As A
GROUP BY [Date], Machine

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS4gR4echKqOuFEgEQIJ8wCeLTBQU34wI8gNUt5nBaNR38fyc9EAnAoV
YLxzBqITLGaYa6Mx7+pGKLul
=RI0s
-----END PGP SIGNATURE-----
 
I will give it a try.

Thanks

-----Original Message-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Assuming "first entry" means the earliest Time, perhaps this:

SELECT [Date], Min([Time]) As FirstEntry, Machine
FROM tableA As A
GROUP BY [Date], Machine

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQS4gR4echKqOuFEgEQIJ8wCeLTBQU34wI8gNUt5nBaNR38fyc9 EAnAoV
YLxzBqITLGaYa6Mx7+pGKLul
=RI0s
-----END PGP SIGNATURE-----
I have at query where I am showing a days production. I
need to pick the first entry, by time, for each machine
for each date.

Fields are
Click to expand...

.
Click to expand...
 
Back
Top