arrowmakers
New member
- Local time
- Today, 17:23
- Joined
- Jun 24, 2019
- Messages
- 1
Hi I hope somebody out there is able to help....
Im farly new to access and have been asked to complete a small project which has me pull my hair out.
Heres the problem :I have a query runs fine, supplies all my data I need , but I need to be able to date diff between to fields in the same column and deliver the date difference to a new field (yet to be created) in the same query , I have tried all i know and nothing works.
My data looks as follows
dt | agent_id | agent_name | Date diff
| | |
30/11/2018 | 1186 | me | 1
| | |
31/11/2018 | 1186 | me | 1
| | |
04/12/2018 | 1186 | me | 4
Any options would help Ive been at this for 2 days ,and am ready to jump out the window, anything please..............
Im farly new to access and have been asked to complete a small project which has me pull my hair out.
Heres the problem :I have a query runs fine, supplies all my data I need , but I need to be able to date diff between to fields in the same column and deliver the date difference to a new field (yet to be created) in the same query , I have tried all i know and nothing works.
My data looks as follows
dt | agent_id | agent_name | Date diff
| | |
30/11/2018 | 1186 | me | 1
| | |
31/11/2018 | 1186 | me | 1
| | |
04/12/2018 | 1186 | me | 4
Any options would help Ive been at this for 2 days ,and am ready to jump out the window, anything please..............
Last edited: