Expressions

I have created a table for our master customer list. We use weeks of the year
for services.In the old excel sheet we use to be able to add the last done
week with the cycle and would give us the next week due.
ex: Week Done 16 Cycle 4 and in a column calculate 20

I believe I need to use this =[Done]+[Cycle]
Now if this is correct not sure where to put it for it to work.
The table is in design view and I have tried this expression in the Default
Value, Validation Rule and the Valation text but keep getting an error
message when I try to save.
I thank you in advance for any help.............. :-)

Don't do in the table but in the query, form, or report.
--
Build a little, test a little.


"CinCin" wrote:

I have created a table for our master customer list. We use weeks of the year
for services.In the old excel sheet we use to be able to add the last done
week with the cycle and would give us the next week due.
ex: Week Done 16 Cycle 4 and in a column calculate 20

I believe I need to use this =[Done]+[Cycle]
Now if this is correct not sure where to put it for it to work.
The table is in design view and I have tried this expression in the Default
Value, Validation Rule and the Valation text but keep getting an error
message when I try to save.
I thank you in advance for any help.............. :-)

Don't do in the table but in the query, form, or report.
--
Build a little, test a little.


"CinCin" wrote:

I have created a table for our master customer list. We use weeks of the year
for services.In the old excel sheet we use to be able to add the last done
week with the cycle and would give us the next week due.
ex: Week Done 16 Cycle 4 and in a column calculate 20

I believe I need to use this =[Done]+[Cycle]
Now if this is correct not sure where to put it for it to work.
The table is in design view and I have tried this expression in the Default
Value, Validation Rule and the Valation text but keep getting an error
message when I try to save.
I thank you in advance for any help.............. :-)

Following on from Karl's answer.

You could just use a date field in your table (for the date when the cycles
was looked at) set the default to Date()

Also (just an idea) I would add another field to the table (number) and this
would be the number of weeks that a cycle needs looking. Set the default to
4 if you want - but you would then be able to change the repetitions if needs
for individual cycles. Up to you though.

Also I would not use dateadd w, unless you work weekends ??
Use a function to give the dateadd w just for week days (mon - fri)

You can a sample of this function here
http://support.microsoft.com/kb/115489

Good luck



--
Wayne
Manchester, England.



"KARL DEWEY" wrote:

Don't do in the table but in the query, form, or report.
--
Build a little, test a little.


"CinCin" wrote:

I have created a table for our master customer list. We use weeks of the year
for services.In the old excel sheet we use to be able to add the last done
week with the cycle and would give us the next week due.
ex: Week Done 16 Cycle 4 and in a column calculate 20

I believe I need to use this =[Done]+[Cycle]
Now if this is correct not sure where to put it for it to work.
The table is in design view and I have tried this expression in the Default
Value, Validation Rule and the Valation text but keep getting an error
message when I try to save.
I thank you in advance for any help.............. :-)