Withholding Period

[Shawie]

I have build a database cattle handling.
I have a table called Treatment Table,this has fields Date of Treatment, Withholding Days and Withholding Date
I have created a sub-form for this table, and I am trying to add the Withholding Days to the Date of Treatment to come up with a future date.

I am new at this and struggling.


Ta

Shawie

[recyan]

Guess, you will have to post more details about your db.
For eg.
tblTreatments
DateOfTreatment
WitholdingDays
WithholdingDate

Which is the primary key?
Are there any other tables involved ?
If yes, what are the relationships ?
Why are you using Sub-Form ?

A textual description of what your db does & what is the role of each table will be more helpful, for people to help.

Thanks

[ssanfu]

Try this ... create a new query:

SELECT DateOfTreatment, WitholdingDays, WithholdingDate, DateAdd("d", WitholdingDays, DateOfTreatment) AS FutureDate FROM tblTreatments

This calculated future date should not be stored in the table because it can be calculated at any time.



Also, as in the field names recyan posted, you shouldn't use spaces or special characters (except the underscore) in object names.

[Shawie]

I have a number of sub-forms within a form
In the sub-form Treatment property sheet (control source) I just want to put a formula in this to calculate a future date

Date of Treatment/Withholding Days/Withholding Period(Future Date) The withholding date changes depends on treatment.
1/1/2013 * 23 = 24/1/2013

I have already completed a formula for my breeding sub-form which works
=DateSerial(Year([StartDate]),Month([StartDate])+9,Day([StartDate])+10)

Ta

[Shawie]

I have a number of sub-forms within a form
In the sub-form Treatment property sheet (control source) I just want to put a formula in this to calculate a future date

Date of Treatment/Withholding Days/Withholding Period(Future Date) The withholding date changes depends on treatment.
1/1/2013 * 23 = 24/1/2013

The withholding days varies depending on treatment, I have tried the following formula, but it dosen't seem to work =DateAdd("d",[WithholdingDays],[DateofTreatment])

I have already completed a formula for my breeding sub-form which works
=DateSerial(Year([StartDate]),Month([StartDate])+9,Day([StartDate])+10)


Any help would be appreciated.

shawie

[ssanfu]

The sub-form Treatment recordsource should be a query, not a table. The query looks like:

SELECT DateOfTreatment, WitholdingDays, DateAdd("d", WitholdingDays, DateOfTreatment) AS FutureDate FROM tblTreatments

Change the table name (in BLUE) to your table name.
Bind "FutureDate" to the control on the form to display the future date.



If you must use a calculated control, the formula would look like:

= DateAdd("d", NameOfWitholdingDaysControl, NameOfDateOfTreatmentControl)

Change the control names (in BLUE) to your control names.