Prev: Find Duplicate Records in two tables
Next: Number of occurences
From: KUMI on 29 Mar 2010 16:50
Add a calculated field for ExitDate, which is when the renter will leave the
unit based on the date the rental started + the length of stay * 7 (to
convert the total time in unit from weeks into number of days)
Hint: StartDate + (Length * 7)
---StartDate, Length are data columns. How can I do this!? I tried: Design
View on the Field row typed:
[StartDate + (Length * 7)]
But it's not working it shows a windows "Enter Parameter Value". Maybe I'm
wrong.
How can I do this!?

*Access 2007
From: KARL DEWEY on 29 Mar 2010 16:58
Try this --
[StartDate] + ([Length] * 7)

--
Build a little, test a little.


"KUMI" wrote:

> Add a calculated field for ExitDate, which is when the renter will leave the
> unit based on the date the rental started + the length of stay * 7 (to
> convert the total time in unit from weeks into number of days)
> Hint: StartDate + (Length * 7)
> ---StartDate, Length are data columns. How can I do this!? I tried: Design
> View on the Field row typed:
> [StartDate + (Length * 7)]
> But it's not working it shows a windows "Enter Parameter Value". Maybe I'm
> wrong.
> How can I do this!?
>
> *Access 2007
From: KUMI on 29 Mar 2010 17:11
It showed up some dates, and i think that's the answer.

Thanks a lot Karl.

"KARL DEWEY" wrote:

> Try this --
> [StartDate] + ([Length] * 7)
>
> --
> Build a little, test a little.
>
>
> "KUMI" wrote:
>
> > Add a calculated field for ExitDate, which is when the renter will leave the
> > unit based on the date the rental started + the length of stay * 7 (to
> > convert the total time in unit from weeks into number of days)
> > Hint: StartDate + (Length * 7)
> > ---StartDate, Length are data columns. How can I do this!? I tried: Design
> > View on the Field row typed:
> > [StartDate + (Length * 7)]
> > But it's not working it shows a windows "Enter Parameter Value". Maybe I'm
> > wrong.
> > How can I do this!?
> >
> > *Access 2007
 | 
Pages: 1
Prev: Find Duplicate Records in two tables
Next: Number of occurences