Subtracting results from one field to add to another

T

TKM

I am adding a field to my query that is not in any of my tables. I want to
subtract one day from my field based off the results in my other field named
start date.

Example:

Start Date End Date
10/13/2006 10/12/2006

Add a new field in my query named End date which will take the date from
above and subtract one day from it and show the results in my new field named
End Date.

Thanks again
 
D

DANIEL BLOOMFIELD

You can add a field to any query by using a ":" between the name and your
calculation.

For example: END DATE: [START DATE]-1

Not sure about the formula for the date, but the brackets around START DATE
names the field. END DATE is the name given to the new field. Depending on
how many tables are in your query, you may have to name your table as
well.... For example, [PROJECT]![START DATE]-1. PROJECT is the table name.

Hope that makes sense.
 
Top