Re: [MS_AccessPros] Re:

 

Hi Penny

It looks like the file has finally made it into our group files which have become accessible again. Let me know if you have any questions. I tried to comment the code so you could see what it does. I could have shortened the code but it would have been more difficult to understand.

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Penny Price misspen1@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, February 7, 2018 2:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re:

 

Hi Duane, 

Yes please! I would love to have a file!

Thanks, 

Penny

On Feb 7, 2018 7:01 AM, "Penny Price" <misspen1@gmail.com> wrote:

Hi Everyone,

 

After a couple of years away from my old Access database my employer once again has me creating a new one. I have a very simple db that is not normalized and is not relational (since I need any changes to be made to all queries, forms, etc.). I'm working in Access 2016, which is a big deal for us since we had Access '99 well into the mid 2000's! My one hang-up at the moment is a query I'm creating to show response time among several variable dates. I have seven different dates (Date1, Date2, Date3,…). Date1 will always have a value and at least one of the other dates will also have a value in this particular query. I do not want to include any rows that only have Date1 without any of the other dates having a value.  However, there could be up to three dates for each individual row: Date1, Date3, Date5 or Date1, Date2, Date6 for example. For each row of the query I need to calculate the number of days between Date1 and each of the variable dates: Days Till A: -DateDiff("d",[Date2],[Date1]) etc. This part works fine, but I also need to find the DateDiff in each row for Date1 and the next earliest date; and then in a separate calculation, the difference between Date1 and the latest date. 

 

The dates on individual rows could look something like this (but is not limited to):

 

Date1, Date2, Date3

Date1, Date3

Date1, Date4

Date1, Date5

Date1, Date2, Date6

 

The only constant for each row is Date1. Date1 is always the earliest date, but Date7 is not necessarily later than Date2, Date3,… Any ideas how I can accomplish this since I have never learned to write VBA? (Something for my retirement!)

 

As always, thanks in advance to all of you truly helpful people!

 

Penny

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___