So I have a table that is pretty simple. It has [ID], [Shot] and I need to calculate the difference in days between each shot for each grouped ID.
I was trying to use DLookUp in SQL(among a few other ways) but it wasn't working for me. I wouldn't say I'm even close to an experienced user, but I do understand a lot of basics and have created a database for my research(albeit using wizards, details form, and the expression builder). That being said, some of the links that I found on previous articles just wasn't working for me. After a few days of tinkering with it on and off, I felt like it was time to post this.
Here's an example where the first two fields are what I want to use in the query, and my desired output for each record. The ID's are all structure like shown. In design view I have it grouped by ID using Totals.
<tbody>
</tbody>
I hope that is enough clarification, but I would be willing to provide a lot more. Thanks in advance
I was trying to use DLookUp in SQL(among a few other ways) but it wasn't working for me. I wouldn't say I'm even close to an experienced user, but I do understand a lot of basics and have created a database for my research(albeit using wizards, details form, and the expression builder). That being said, some of the links that I found on previous articles just wasn't working for me. After a few days of tinkering with it on and off, I felt like it was time to post this.
Here's an example where the first two fields are what I want to use in the query, and my desired output for each record. The ID's are all structure like shown. In design view I have it grouped by ID using Totals.
ID | Shot | Value Desired |
JB0123 | 9/18/13 | 0 |
JB0123 | 9/20/13 | 2 |
JB0123 | 9/29/13 | 9 |
AB0101 | 7/1/13 | 0 |
AB0101 | 7/8/13 | 7 |
<tbody>
</tbody>
I hope that is enough clarification, but I would be willing to provide a lot more. Thanks in advance