Re: [MS_AccessPros] Subtracting 2 dates on the same column

 

Hi Tim,

Can you help us out by providing some sample data with actual table and field names as well as your desired output? 

Do you need this query to allow edits?

Regards,

Duane Hookom

Minnesota

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of timdbui@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, November 13, 2017 12:32 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Subtracting 2 dates on the same column

 

Hello,

I have a table that has  Column A containing different dates (say 1/1/2017, 2/15/2017, 4/11/2017,....) How can I calculate the number of days since the previous dates in a queries. Thank you so much for your help! Tim

__._,_.___

---

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 (2)

---

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

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___