Query. How to add this calculated field?

K

KUMI

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
 
K

KUMI

It showed up some dates, and i think that's the answer.

Thanks a lot Karl.

KARL DEWEY said:
Try this --
[StartDate] + ([Length] * 7)

--
Build a little, test a little.


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria on calculated field in parameter query 2
Calculated field 5
calculated field 11
sql query needed urgent 4
table formatting not carrying to calculated field in query 4
Concatenation Limit in Calculated Query Field 2
How do you create a before and after date query? 1
Complicated Calculated Field Logic 0

Top