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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:

Date2:DATEADD("d",-30,[Date1])

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

Hope this helps

Judith
 
Hi again,

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

Mark

JudithJubilee said:
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:

Date2:DATEADD("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
.
Click to expand...
Click to expand...
 
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

JudithJubilee said:
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:

Date2:DATEADD("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
.
Click to expand...
Click to expand...
.
Click to expand...
 
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.

JudithJubilee said:
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

JudithJubilee said:
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:

Date2:DATEADD("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
.
Click to expand...
.
Click to expand...
Click to expand...
 
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.

JudithJubilee said:
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
Click to expand...
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:

Date2:DATEADD("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
.


.
Click to expand...
Click to expand...
.
Click to expand...
 
Back
Top