• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

MS ACCESS QUERY QUESTION

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.
0
BOEING39
Asked:
BOEING39
  • 2
1 Solution
 
Dale FyeCommented:
This is pretty vague, can you provide a sample of what the data would look like, and what the query results would look like?
0
 
Gustav BrockCIOCommented:
That could be:

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

/gustav
0
 
BOEING39Author Commented:
Quick accurate response.   Formula was exactly what I needed.   Thx
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now