ACCESSS. Take date 1 less 30 days to give date 2

[Mark]

Any body know how to use a DATE field (Date1) and create another DATE field
30 days before (Date2)

I.E. 10-Sept-2005 = Date1
11-Aug-2005 = the result of the calculation in Date2

 

[JudithJubilee]

Hello there,

You will need to create a query.

1. Create a new query.
2. Add the fields you would like.
3. In the next empty column you need a calculated field:

Date2ATEADD("d",-30,[Date1])

Date2 - the name for the new field
: - Seperates the Name from the calculation

Hope this helps

Judith

 

[Mark]

Hi again,

I get the correct answer in the query but cannot get it to work in a form
any Ideas
Regards

Mark

Hello there,

You will need to create a query.

1. Create a new query.
2. Add the fields you would like.
3. In the next empty column you need a calculated field:

Date2ATEADD("d",-30,[Date1])

Date2 - the name for the new field
: - Seperates the Name from the calculation

Hope this helps

Judith

-----Original Message-----
Any body know how to use a DATE field (Date1) and create another DATE field
30 days before (Date2)

I.E. 10-Sept-2005 = Date1
11-Aug-2005 = the result of the calculation in Date2
.

 

[JudithJubilee]

Hello there again,

If you are adding it to a form:

1. Add a Text Box to the form.
2. In the Unbound part of the text box type:

=dateadd("d",-30,[Date1])

Hopes this solves it

Judith

-----Original Message-----
Hi again,

I get the correct answer in the query but cannot get it to work in a form
any Ideas
Regards

Mark

Hello there,

You will need to create a query.

1. Create a new query.
2. Add the fields you would like.
3. In the next empty column you need a calculated field:

Date2ATEADD("d",-30,[Date1])

Date2 - the name for the new field
: - Seperates the Name from the calculation

Hope this helps

Judith

-----Original Message-----
Any body know how to use a DATE field (Date1) and create another DATE field
30 days before (Date2)

I.E. 10-Sept-2005 = Date1
11-Aug-2005 = the result of the calculation in Date2
.

.

 

[Mark]

Hi Judith,

Sorted
Add all data entry into a table, import all into a query adding formula
along the way, then create the form delating what is not needed from the
original table.

Hello there again,

If you are adding it to a form:

1. Add a Text Box to the form.
2. In the Unbound part of the text box type:

=dateadd("d",-30,[Date1])

Hopes this solves it

Judith

-----Original Message-----
Hi again,

I get the correct answer in the query but cannot get it to work in a form
any Ideas
Regards

Mark

Hello there,

You will need to create a query.

1. Create a new query.
2. Add the fields you would like.
3. In the next empty column you need a calculated field:

Date2ATEADD("d",-30,[Date1])

Date2 - the name for the new field
: - Seperates the Name from the calculation

Hope this helps

Judith

-----Original Message-----
Any body know how to use a DATE field (Date1) and
create another DATE field
30 days before (Date2)

I.E. 10-Sept-2005 = Date1
11-Aug-2005 = the result of the calculation in
Date2
.

.

 

[JudithJubilee]

Hello Mark,

You can just create the query and then base the form on
the query rather than on the table

Judith

-----Original Message-----
Hi Judith,

Sorted
Add all data entry into a table, import all into a query adding formula
along the way, then create the form delating what is not needed from the
original table.

Hello there again,

If you are adding it to a form:

1. Add a Text Box to the form.
2. In the Unbound part of the text box type:

=dateadd("d",-30,[Date1])

Hopes this solves it

Judith

-----Original Message-----
Hi again,

I get the correct answer in the query but cannot get

it
to work in a form

any Ideas
Regards

Mark

:

Hello there,

You will need to create a query.

1. Create a new query.
2. Add the fields you would like.
3. In the next empty column you need a calculated field:

Date2ATEADD("d",-30,[Date1])

Date2 - the name for the new field
: - Seperates the Name from the calculation

Hope this helps

Judith

-----Original Message-----
Any body know how to use a DATE field (Date1) and
create another DATE field
30 days before (Date2)

I.E. 10-Sept-2005 = Date1
11-Aug-2005 = the result of the calculation in
Date2
.


.

.