logo
  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Category: Access

Creating Access ‘Jobs’, and Triggering Them from Outlook

May 20, 2014 0 comments Article Access, Advanced, Outlook

  In this post, I’m going to cover how to create a ‘Job’ in Access, and how to setup a reminder in Outlook, including a ‘Trigger from Outlook’ button. This post assumes you’re largely familiar with importing data into access (I’ll try and do a post on this some time, for those of you less Read More

Finding the Difference Between Two Dates in SQL

July 9, 2013 0 comments Article Access, Access, Easy, Excel, SQL, SQL Server, Teradata

In this post, I’m going to talk about finding the difference between 2 dates in SQL. However, I’m going to cover it across multiple applications. The Problem Statement is simple: How many days are there between two dates? What we want is an integer value back of how many days there are. The solution will Read More

Most Read Articles

Showing a Picture Based on the Value of another Cell in Excel
Using SUMPRODUCT to create a Conditional Weighted Average in Excel
Showing Data Bars as a 'Proportion to Total' in Excel
Format or Remove Borders from a Slicer or Timeline in Excel
Populate a Dropdown Based on the Value of Another Dropdown in PowerApps
Using the same Named Range in multiple worksheets, but with different values, in Excel

Meta

  • Register
  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Categories

Pages

  • Excel Charts
  • About David Aldred & This Blog
  • Consulting & Excel Support

Copyright System Secrets 2021 - Theme by ThemeinProgress