Many data in a single field

[Dev]

I have a proximity attendedce time managment system in our office. The
problem is that the reader sends all the relevant data in a single
field in a particular table. E.g.
00D057290010512036:1340* 0000*:5:5:G
00D001396010512132:1335* 0000*:5:5:G
The avobe contains the card no, date and the time. From feft hand side
6-9th is the cad no, 12-17th is the date in yymmdd format and 20-23rd
is the time. Rest are all unnecessary.

How can I create a report where for a particular card the daily/monthly
attendence along with time in/out can be generated ?
Is MS Access report enough or I need Visual Basic to achieve this.
Thanks for any help.

- Dev

 

[Allen Browne]

Create a query, with calculated fields.

Use Left(), Mid(), Right(), and Len() to parse the values into different
fields.

Use DateSerial() and DateAdd() or TimeSerial() to create the date/time
value.