I am about to throw this computer out the window, please help......
I have a query that returns all the value I require, except, that the date is all in one column , nothing I can do about that
As all the date data is in the same Column I can not use datediff to calculate the date difference, is ther any options open to me I think I have tried all
options, but being new to access Im not certain if I have other options ie:SQL statement (which I know very little about) or something else
my data reports back like this......
dt | Agent_ID | Agent_name | date difference(This field is the one needed)
20/11/2018 | 11156 | Me |
22/11/2018 | 11452 | Me |
30/11/2018 | 23145 | Me |
Any help would be greatly appreciated
Cheers