1 Replies - 185 Views - Last Post: 10 November 2017 - 02:05 AM Rate Topic: -----

#1 gemharl325  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 09-November 17

Printing Biometric Time record

Posted 10 November 2017 - 01:38 AM

Hi,

I would like to ask a favor if maybe you can help me with the codes for printing bio-metric daily time record.
which has a mysql databse table that look like this:

AccessNo date time
1119 2017-10-01 08:24:44
1118 2017-10-01 08:42:54
1118 2017-10-01 12:00:56
1119 2017-10-01 12:05:26
1118 2017-10-01 12:42:54
1119 2017-10-01 12:52:34
1118 2017-10-01 17:00:56
1119 2017-10-01 17:03:36


And now I want to query it in Listview or datagridview
and view it like this:
for Employee which has an AccessNo of 1118
date IN out IN out
2017-10-01 08:42:54 12:00:56 12:42:54 17:00:56

and for Employee which has an AccessNo of 1119
date IN out IN out
2017-10-01 08:24:44 12:05:26 12:52:34 17:03:36

I hope you can help me with this,

Cheers,

Is This A Good Question/Topic? 0
  • +

Replies To: Printing Biometric Time record

#2 andrewsw  Icon User is offline

  • the case is sol-ved
  • member icon

Reputation: 6376
  • View blog
  • Posts: 25,763
  • Joined: 12-December 12

Re: Printing Biometric Time record

Posted 10 November 2017 - 02:05 AM

What have you thought about or attempted? What is your specific question?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1