Posted on 2011-05-06
Last Modified: 2012-05-11
I need assistence developing an MS query formula for due dates based on a "Calibration Date"  DB "Column" & a "Due Date" Column.   The column formula I am looking for would count down in days to the due date and go negative when
going past the due date.
Question by:BOEING39
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    This is pretty vague, can you provide a sample of what the data would look like, and what the query results would look like?
    LVL 48

    Accepted Solution

    That could be:

    DueDays: DateDiff("d",Date(),[Due Date])


    Author Closing Comment

    Quick accurate response.   Formula was exactly what I needed.   Thx
    LVL 48

    Expert Comment

    by:Gustav Brock
    You are welcome!


    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now