Problems with an update query - using calculations

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I have three fields
"Days leased"- (which is blank) , and date-out and date-in
days leased needs to be updated so that the differeence between the two
dates in days are displayed
However I am trying to type in the update to column: [Date-out]-[Date-in]
but nothing shows up, the days leased column still remains blank! and the
date out and date in fields are not shown either (as they were in the select
query)
Even my access tutor can't help me

I appreciate any help
 
Ben, you *really* need to remove the [Days leased] field from your table.

Then create a query, and type this expression into the Field row in query
design:
DaysLeased: [Date-out]-[Date-in]

Now use the query anywhere you would have used the table (e.g. as the source
for a form or report.) There is no problem with trying to update the field,
and it can't go wrong.

More info:
Calculated fields
at:
http://allenbrowne.com/casu-14.html
 
Back
Top