calculate dates between 2 fields in a table

  • Thread starter evilc via AccessMonster.com
  • Start date
E

evilc via AccessMonster.com

Hello, I am trying to create query where I can input a date and an interval
and access will automatically figure out what the calculated date should be.
But, when I run the query all I am getting is blank data. Here is how I have
it:

Field: Selected Date
Table: dates
Criteria: [Enter Date]

Field: Interval Parameter
Table: Dates
Criteria: [Enter Interval]

Field: Expr1: DateAdd("d",+[Interval Parameter],[Selected Date])

I have no field in the table for the last entry. When I run the query it
asks me to input the date and the interval and should display my answer in
the expression column but I am getting blank data in all 3 columns. Does
anyone know what I am doing wrong? Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Divide a a range of dates into intervals starting with the current date or the latest date in the ra 2
query to show where no data in a stated column 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating a Search using a combo box and then creating a report. 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Append Crosstab Query to Existing Table 0
Creating a Chart on form from selected data in query. 0

Top